Welcome!   |  Search Scrabble® Dictionary using DLD   |  Statistics   |  Compare any two Strings using DLD   |  Reference   |  Your IP

Dictionary Search Results using Damerau-Levenshtein distance in T-SQL

Here are the results of your fuzzy-string dictionary search for “warison” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

178 similar words found! Changes to Transform each Found Word to your word are shown as:
 remove a letter ~ replace a letter ~ swap two letters ~ _add a letter from your word
(Use the links in the Changes column to see more Transformation details.)

Found WordScrabble ScoreSearched PreviouslyFound PreviouslyChangesTo Transform to your Word
warison103708(None) 
warisons1136901warisons
arisen65316792_arisen
arson55118832_ar_son
garrison943982garrison
grison7310102_grison
malison939692malison
orison6411662_orison
parson83817902par_son
prison8514022_prison
wanion93213062wani_on
anion55028813_ani_on
archon11311753_archon
argon65520593_ar_gon
ariose64818723_ariose
ariosi64313033_ariosi
arioso64312403_arioso
ariosos7409853_ariosos
arise56436433_aris_e
arises65233803_arises
arising83619973_arising
arista6415293_arista
aristo6414033_aristo
aristos7312383_aristos
arsino64113513_arsino
arsons63917213_ar_sons
artisan759463_artisan
avion84218343_avi_on
aviso85713963_aviso_
avisos95410483_avisos
axion1211316913_axi_on
barista9310823barista
baritone1058643baritone
baron78131243bar__on
bartisan1056163bartisan
baryon111211613bar_yon
baryton1246003baryton
basion84315853basi_on
benison937123benison
bison75716983__bison
caisson936593caisson
camion103917193cami_on
caparison1343983caparison
carbon104919043car_bon
cardon94120853car_don
cardoon104813813cardoon
caribou1156993caribou
carillon1046963carillon
carrion9312673carrion
carryon1237033carryon
carton84522663car_ton
cartoon94114463cartoon
cation83925503cati_on
chrismon1544643chrismon
chrisom1466623chrisom
clarion9311663clari_on
crimson1135643_crimson
daikon11217243da_ikon
daimon9259713da_imon
damson938063da_mson
derision939073derision
durion7510963duri_on
erasion7311963erasion
fanion94514323fani_on
foison948933_foison
frisson1045313_frisson
gabion93211033gabi_on
garcon92912483gar_con
garish104516933garis_h
garrisons1043793garrisons
garron73113493gar_ron
grisons838993_grisons
haricot12311963haricot
harijan1735783harijan
harissa1035503harissa
harpoon1238313harpoon
horizon1955763horizon
imprison1244793imprison
jargon1448823jar_gon
jargoon1545193jargoon
kation104315683kati_on
lardon74415063lar_don
lardoon83410373lardoon
laris54737463laris__
liaison744473liaison
lyricon1243713lyricon
malisons1048783malisons
mansion9611543mansion
marish114319063maris_h
maroon83118203mar_oon
marron83717543mar_ron
mason74820183ma__son
morion86217733mori_on
naris55735293naris__
nasion63914083nasi_on
nation64322803nati_on
orisons7310563_orisons
paisan84417073pa_isan
paragon10311023paragon
parasol939553parasol
pardon94618733par_don
parian83223963pari_an
paris75145943paris__
parises94827193parises
parish115022363paris_h
parsons93516873par_sons
partisan1058423partisan
parton84720993par_ton
passion9310883passion
perigon1039853perigon
person83517873per_son
poison8312223_poison
prion75119993_pri_on
prisons9313223_prisons
raisin62716923ra_isin
ramson8310463ra_mson
ration64226013rati_on
rerisen73613643rerisen
risen54621883__risen
sadiron836043sadiron
samisen937673samisen
sarin55239253sari__n
saris54544953saris__
sarsen6314233sar_sen
talion6317713tali_on
tardyon1134673tardyon
tarpon82812803tar_pon
torsion7310803torsion
trigon74513103_trigon
triton63914893_triton
turion6313163turi_on
unison649033_unison
unrisen7229283unrisen
uprisen9227353uprisen
varistor1146393varistor
venison1036453venison
version10310923version
virion9310683viri_on
wadis95223963wadis__
waggon1136393wa_ggon
wagon94312953wa__gon
wain75840203wa_i__n
wairs86424063wairs__
waist86132383wa_is_t
waists97415453wa_ists
waitron1036333waitron
wanigan1135213wanigan
wanions104011373wani_ons
wanton94413813wa_nton
warden104515513war_den
wards97734403wards__
wares88250583wares__
warier93722893wari_er
wariest105122503wariest
warily122915093wari_ly
waring105029443wari_ng
warks127932403warks__
warmish1538373warmis_h
warms107726853warms__
warn75239323war___n
warns87231003warns__
warps107126423warps__
warren95012863war_ren
warrior1045363warrior
wars78659803war_s__
warsaw1236193war_saw
warsle93112923war_sle
warthog1444543warthog
warts814840403warts__
warworn1357353warworn
wearish132310153wearis_h
wearisome1453273wearisome
weason93210823w_eason
whoreson1444013whoreson
worsen95513873wor_sen
wrist84827563w_ris_t
wrists95415643w_rists
wristy12509703w_risty

Search took 7 seconds overall (including website activity, plus SQL activity in the following phases):

  1. Length Filter: Limit the application of DLD to words with length difference of no more than the Change Limit.
  2. DLD Change Limit: Apply DLD to each remaining word, limiting each comparison according to the Change Limit.
  3. Display Results: Return the results, with similar words marked up to highlight differences.
SeqSearch PhaseWords CheckedWords MatchedSecondsWords Per Sec
1Length Filter1786911340270.406440125.6
2DLD Change Limit1340271786.23621492.5
3Display Results1781780.0632825.4
 (SQL Overall)1786911786.70526650.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  Published At: SQLServerCentral (with Source Code)  |  Presented At: SQLSaturday #144  |  Demonstrated For: Sacramento SQL Server User Group  |  Developed For: Repo Remarketing  |  Running On: Microsoft SQL 2014 RTM Standard on Server 2012 R2 (also successfully run on SQL 2012 Web Edition, SQL Express 2008-2008R2, and SQL Server 2000-2005 Standard)  |  SQL Performance Monitoring By: Confio Ignite  |  American Scrabble® Dictionary From: Internet Scrabble Club  |  Scrabble® is a registered trademark. All intellectual property rights in and to the game are owned in the U.S.A and Canada by Hasbro Inc., and throughout the rest of the world by J.W. Spear & Sons Limited of Maidenhead, Berkshire, England, a subsidiary of Mattel Inc. Mattel and Spear are not affiliated with Hasbro. This site is not affiliated with Scrabble®, Mattel, Spear, or Hasbro in any way. This site is for entertainment and technical education purposes only.