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

231 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
wraiths135503(None) 
wraith1258601wraith_
wraths123810081wra_ths
briths115113862br_iths
faiths124610272_faiths
friths124313582fr_iths
griths105211652gr_iths
kraits104912202krait_s
raitas64417672_raitas
traits65121982trait_s
waits88333522w_ait_s
warmths1583782warmths
wealths13365812wealths
wrath115715872wra_th_
wrathy15377852wra_thy
wreaths13338372wreaths
writes94420332wr_ites
writhe125310702wr_ithe
writhes134811702wr_ithes
writs86624382wr_it_s
airths95414253__airths
aits46355533__ait_s
awaits96411953await_s
baith108023133_baith_
baits76630583_bait_s
barites94322333barites
baths105922923_ba_ths
brachs134415753bra_chs
bracts105617773bract_s
braids95015693brai_ds
brails84621293brai_ls
brains85125473brai_ns
braises93818873braises
braizes183112453braizes
brants85723053brant_s
brats75336013bra_t_s
breadths1474463breadths
breaths124411183breaths
brith104924373br_ith_
brits76433083br_it_s
britts84813443br_itts
broths115013923br_oths
bruits85714453bruit_s
caritas93316963caritas
crafts115312743craft_s
crates85736063cra_tes
crits75527573cr_it_s
crwths1433433cr_wths
dearths11498843dearths
deaths105914443dea_ths
drafts105012533draft_s
drails74716953drai_ls
drains73719403drai_ns
drats66628373dra_t_s
droits74314313droit_s
drouths11436483drouths
earths95014593_earths
eoliths10318573eoliths
faith115620853_faith_
fractus12146593fractus
frails93716473frai_ls
fraises104215693fraises
frats86829673fra_t_s
frites94922483fr_ites
frith115922033fr_ith_
frits86129103fr_it_s
fritts94613193fr_itts
froths125411443fr_oths
fruits94512493fruit_s
gaits65726013_gait_s
garths104111503_garths
grafts105013253graft_s
grails77518783grai_ls
grains74223093grai_ns
granitas92610223granitas
granites92116363granites
grants73722473grant_s
graphs124510153gra_phs
grates75429893gra_tes
gratins84119183gratins
gratis74819243gra_tis
gravitas12316013gravitas
grith95520373gr_ith_
grits65529583gr_it_s
growths1494423growths
hadiths1436023hadiths
healths13478753healths
hearths135311073hearths
heaths126316383hea_ths
iritis63113733ir_itis
kiths125814973__kiths
krafts13438853kraft_s
krait94726773krait__
krauts10418513kraut_s
laichs115110893_laichs
laighs10508803_laighs
laith85722103_laith_
laths86022403_la_ths
maths105624023_ma_ths
oaths86117313_oa_ths
ooliths10268323ooliths
orates64328613ora_tes
orbits84211443orbit_s
ornithes1136423ornithes
pariahs123812343pariahs
paths105521383_pa_ths
piths105817543__piths
plaits83816473plait_s
praises94121103praises
prates84633163pra_tes
prats76333393pra_t_s
quaichs2144633quaichs
quaighs2043493quaighs
rafts87820633_raft_s
raias54631123_rai_as
raids65827513_rai_ds
rails55937403_rai_ls
rains55140233_rai_ns
rais45252623_rai__s
raises64826543_raises
raita54623073_rait_a
rajahs16497663_rajahs
ralphs1135373_ralphs
rants55935343_rant_s
rates55352013_ra_tes
rath76037663_ra_th_
rathe85821923_ra_the
ratios64922673_ratios
ratites74920683_ratites
ratos55528763_ra_tos
rats46260373_ra_t_s
rayahs12579193_rayahs
riatas63915093_riatas
rites54442553_r_ites
rouths95416823_rouths
rowths12458173_rowths
ruths85714643_r_uths
saith85826553_saith_
saithe94713913_saithe
scraichs1543993scraichs
scraighs1443633scraighs
smiths114711023_smiths
snaths95112913sna_ths
spaits85017473spait_s
staithe1037723staithe
staithes1138953staithes
straits74916323strait_s
straths102711723stra_ths
swarths13537323swarths
swaths125312643swa_ths
tracts85019073tract_s
traiks104013713trai_ks
trails64622513trai_ls
trains64725343trai_ns
trait56940843trait__
traitor7310123traitor
traitors8310793traitors
triliths1145953triliths
troths95414153tr_oths
trowths1365023trowths
truths9449503tr_uths
turbiths1374083turbiths
unfaiths1443213unfaiths
uralites82112723uralites
uranites82514643uranites
urates65027763ura_tes
uroliths1154923uroliths
wafts116920553w_aft_s
waifs115719873w_ai_fs
wails86631483w_ai_ls
wains86930873w_ai_ns
wairs86424063w_ai_rs
waists97415453w_aists
wait75553693w_ait__
waited103819773w_aited
waiter94321253w_aiter
waiters104218623w_aiters
waives123714183w_aives
wants87932213w_ant_s
wapitis1236473wapitis
warmth1477933warmth_
warpaths1643973warpaths
warts814840403w_art_s
wastes96224883w_astes
wasts87433673w_ast_s
wats77555883w_a_t_s
watts86923093w_a_tts
wealth12379223wealth_
wealthy16314333wealthy
weighs13338873w_eighs
whats117718993wha_t_s
whites123919883w_hites
whits115923823w_hit_s
widths1335123w_idths
wites85536963w__ites
with105730473w__ith_
withe115220233w__ithe
withes124620843w__ithes
withy144813763w__ithy
wits76044873w__it_s
worrits10258683worrit_s
worths127812893w_orths
wracks154711113wra_cks
wrangs104611913wra_ngs
wraps105617153wra__ps
wrapt105123183wrapt__
wrasses103812593wrasses
wrastle10368993wrastle
wrastles11328933wrastles
wrathed14298523wra_thed
wreath124111193wreath_
wreathe13339053wreathe
wreathes14299893wreathes
wreathy16326063wreathy
wrests95313083wrest_s
wricks154610623wr_icks
wries85827743wr_i_es
wright133713513wr_ight
wrights14318993wr_ights
wrings104012973wr_ings
wrists95415643wr_ists
writ75537913wr_it__
write85522833wr_it_e
writer94416513wr_iter
writers105513493wr_iters
writhed14389623wr_ithed
writhen13407863wr_ithen
writher134010853wr_ither
writhers14398983wr_ithers
wroth116815883wr_oth_
zeniths1935153zeniths

Search took 8 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.420425454.8
2DLD Change Limit1340272317.05019010.9
3Display Results2312310.0763039.5
 (SQL Overall)1786912317.54623680.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  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.