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 “wraith” 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.

364 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
wraith125860(None) 
wraiths1355031wraiths
wrath115715871wra_th
baith108023132_baith
brith104924372br_ith
faith115620852_faith
frith115922032fr_ith
grith95520372gr_ith
krait94726772krait_
kraits104912202kraits
laith85722102_laith
raita54623072_raita
rath76037662_ra_th
saith85826552_saith
trait56940842trait_
traits65121982traits
wait75553692w_ait_
waits88333522w_aits
warmth1477942warmth
wealth12379222wealth
with105730482w__ith
wrapt105123182wrapt_
wraths123810082wra_ths
wrathy15377852wra_thy
wreath124111192wreath
writ75537912wr_it_
write85522832wr_ite
writhe125310702wr_ithe
writs86624382wr_its
wroth116815882wr_oth
airth85621023__airth
ait38093913__ait_
aitch105216163__aitch
aits46355543__aits
await85524493await_
awaits96411953awaits
bait66556003_bait_
baits76630583_baits
barite84224813barite
bath95940083_ba_th
brach126123303bra_ch
bract96332723bract_
bracts105617773bracts
braid85822263brai_d
braids95015693braids
brail75525553brai_l
brails84621293brails
brain76229383brai_n
brains85125473brains
brainy114815643brainy
braise84318753braise
braize174113113braize
branch134014783branch
brant74742173brant_
brants85723053brants
brash106221563bra_sh
brat66055543bra_t_
brats75336013bra_ts
bratty1159683bratty
breadth1365993breadth
breath113916263breath
brit66350153br_it_
briths115113863br_iths
brits76433083br_its
britt75732233br_itt
broth106521093br_oth
bruit76126723bruit_
bruits85714453bruits
craft105327663craft_
crafts115312743crafts
crafty14478913crafty
cranch133613533cranch
crash109120013cra_sh
cratch134110793cratch
crate76537403cra_te
crit65743713cr_it_
crits75527573cr_its
crwth1337483cr_wth
dearth104212513dearth
death94822523dea_th
draft95526683draft_
drafts105012533drafts
drafty13638933drafty
drail65020973drai_l
drails74716953drails
drain65222893drai_n
drains73719403drains
drat56247833dra_t_
drats66628373dra_ts
dreich12377723dreich
dreigh11246443dreigh
droit65127123droit_
droits74314313droits
drouth104410103drouth
dryish1336323dryish
earth85023053_earth
eath75735663_ea_th
eolith93013903eolith
faiths124610273_faiths
fracti1139963fracti
frail85220213frai_l
frails93716473frails
frailty1335663frailty
fraise94214913fraise
frat75648543fra_t_
frats86829673fra_ts
frit77044473fr_it_
friths124313583fr_iths
frits86129103fr_its
fritt86129413fr_itt
fritz176020773fr_itz
froth115919283fr_oth
fruit85122223fruit_
fruits94512493fruits
fruity12429703fruity
gait56150193_gait_
gaits65726013_gaits
garish104516933garish
garth94720223_garth
graft95327203graft_
grafts105013253grafts
grail64622873grai_l
grails77518783grails
grain65126253grai_n
grains74223093grains
grainy103914213grainy
granita82111303granita
granite82017083granite
grant64840023grant_
grants73722473grants
graph115315613gra_ph
grat55651283gra_t_
grate64932883gra_te
gratin74520583gratin
gratis74819243gratis
gravity1437183gravity
grayish1437813grayish
grit55247243gr_it_
griths105211653gr_iths
grits65529583gr_its
growth1377383growth
hadith13312063hadith
hath105933913_ha_th
health124712143health
hearth125315213hearth
heath115724283hea_th
irate55627983ira_te
kith115826373__kith
kraft125721013kraft_
krafts13438853krafts
kraut95221403kraut_
krauts10418513krauts
laich105920713_laich
laigh95515923_laigh
laity85318903_laity
lath76640383_la_th
loath84918603loa_th
marish114319063marish
math95437453_ma_th
neath86020283nea_th
oath76132153_oa_th
oolith93813243oolith
orach105219233ora_ch
orality101111683orality
orate55133303ora_te
orbit73622063orbit_
orbits84211443orbits
pariah114320593pariah
parish115022363parish
parity114719873parity
path99134913_pa_th
pith95432703__pith
plait75631573plait_
plaits83816473plaits
praise84419413praise
prat65952043pra_t_
prate75135983pra_te
prats76333393pra_ts
quaich2047693quaich
quaigh1935463quaigh
radish103516923_radish
raft76245913_raft_
rafts87820633_rafts
rah68052403_ra__h
rai37658223_rai__
raia46638383_rai_a
raias54631123_raias
raid55243083_rai_d
raids65827523_raids
rail46147763_rai_l
rails55937403_rails
rain46251733_rai_n
rains55140233_rains
rainy85921083_rainy
rais45252623_rai_s
raise54828053_raise
raitas64417673_raitas
rajah155711423_rajah
rakish134313973_rakish
ralph1078743_ralph
ranch105019793_ranch
rant45864683_rant_
rants55935343_rants
rapt67245313_rapt_
rarity93615493_rarity
rash76039933_ra_sh
rat37892743_ra_t_
ratch104221363_ratch
rate45458763_ra_te
rathe85821923_ra_the
ratio55227583_ratio
ratite65022423_ratite
rato45436973_ra_to
rats46260373_ra_ts
ratty84819593_ratty
ravish123414043_ravish
rawish123012923_rawish
rayah116013503_rayah
riata54618023_riata
rich97025553_r_ich
rite45849463_r_ite
ritz135129993_r_itz
routh86423073_routh
rowth115713233_rowth
ruth76825993_r_uth
saithe94713913_saithe
scraich1436763scraich
scraigh1335673scraigh
sith75435163__sith
smith107818053_smith
snath86419803sna_th
spait75631603spait_
spaits85017473spaits
staithe1037723staithe
strait64025893strait_
straits74916323straits
strath93216373stra_th
swarth126012083swarth
swath115920383swa_th
swith115917403_swith
tract75635713tract_
tracts85019073tracts
traik95418203trai_k
traiks104013713traiks
trail55126773trai_l
trails64622513trails
train56529113trai_n
trains64725343trains
traitor7310123traitor
trapt76433393trapt_
trash86119763tra_sh
trilith10310513trilith
trite54730033tr_ite
troth85622203tr_oth
trowth1277883trowth
truth85214153tr_uth
turbith1267113turbith
unfaith1345783unfaith
uralite71714103uralite
uranite72515693uranite
urate55432163ura_te
uratic83016363uratic
urolith1048783urolith
waft106139003w_aft_
wafts116920553w_afts
waif105836753w_ai_f
waifs115719873w_aifs
wail75238823w_ai_l
wails86631483w_ails
wain75840203w_ai_n
wains86930873w_ains
wair75830053w_ai_r
wairs86424063w_airs
waist86132383w_aist
waists97415453w_aists
waited103819773w_aited
waiter94321253w_aiter
waive114214603w_aive
waltz17615473w_altz
want76156173w_ant_
wants87932213w_ants
wapiti1138363wapiti
warier93722893warier
warily122915093warily
waring105029443waring
warmish1538373warmish
warmths1583783warmths
warpath1545203warpath
wart77866083w_art_
warts814840403w_arts
warty119323823w_arty
wash106033813w_a_sh
wast75655853w_ast_
waste86125053w_aste
wasts87433673w_asts
wat67378923w_a_t_
watch135617063w_atch
wats77555883w_a_ts
watt75545413w_a_tt
watts86923093w_atts
waugh125411683w_augh
weakish17217173weakish
wealths13365813wealths
wealthy16314333wealthy
wearish132310153wearish
weigh125412513w_eigh
what105434073wha_t_
whats117718993wha_ts
which163910083w_hich
whish144512923w_hish
whit104834173w_hit_
white114920303w_hite
whits115923823w_hits
whity145513473w_hity
wich125724753w__ich
widish13419363widish
width12310973w_idth
winish124212273winish
wish107228743w__ish
wit66563783w__it_
witch134517563w__itch
wite75443283w__ite
withe115220233w__ithe
withy144813763w__ithy
wits76044883w__its
wormish1537163wormish
worrit92313313worrit_
worrits10258683worrits
worth117120523w_orth
wrack145413883wra_ck
wracks154711113wracks
wrang94716113wra_ng
wrangs104611913wrangs
wrap96821973wra__p
wraps105617153wra_ps
wrasse9398773wrasse
wrastle10368993wrastle
wrathed14298523wra_thed
wreathe13339053wreathe
wreaths13338373wreaths
wreathy16326063wreathy
wrench14439353wrench
wrest84925433wrest_
wrests95313083wrests
wretch14326533wretch
wrick144013393wr_ick
wried95518563wr_ied
wrier84521753wr_ier
wries85827743wr_ies
wright133713513wr_ight
wring95920713wr_ing
wrist84827563wr_ist
wrists95415643wrists
wristy12509703wristy
writer94416513wr_iter
writes94420333wr_ites
writhed14389623wr_ithed
writhen13407863wr_ithen
writher134010853wr_ither
writhes134811703wr_ithes
wrote84717483wr_ote
wrying13379623wrying
zenith1839073zenith
zizith1744823zizith

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 Filter1786911127160.390458182.1
2DLD Change Limit1127163646.25318025.9
3Display Results3643640.1063434.0
 (SQL Overall)1786913646.74926476.7
 
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.