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

134 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
thready1443590(None) 
thread105011091thread_
threads11419951threads
already1144262already
bready124511182_bready
heady125117262_h_eady
ready94821502__ready
therapy1536612therapy
threaded1366322threaded
threader1256732threader
threap11569662threa_p
threaps12488642threaps
threat95020462threa_t
threats104311672threats
threnody1543322threnody
throaty13428482throaty
tread64821702t_read_
treads74817922t_reads
treaty94414352t_reaty
trendy10469602t_rendy
unready11215942unready
ahead96817053ah_ead_
beady114719923__beady
bread85523113_bread_
breads95419203_breads
charlady1743403charlady
creaky154911553_creaky
creamy134811363_creamy
creasy114612303_creasy
dread74419023_dread_
dreads84115023_dreads
dreamy12509993_dreamy
dreary104611673_dreary
forelady1545073forelady
freaky16439233_freaky
greasy10419463_greasy
greedy11518843_greedy
head87137173_h_ead_
heads95127113_h_eads
heapy135914983_h_eapy
heavy144814183_h_eavy
leady95618603__leady
oread64619603_oread_
oreads73915773_oreads
phreak1536153phrea_k
phreaks1634543phreaks
phrensy1533623phrensy
read55942533__read_
readd74617133__readd
reads64835273__reads
reedy910020283__reedy
reread71715433reread_
rereads81512293rereads
rethread1245353rethread_
rethreads1344483rethreads
screaky16436213screaky
shady125416513sh__ady
shred98125613shre_d_
shreds105613053shre_ds
shrewd136810773shrewd_
shrewdly1842523shrewdly
spread9312533spread_
spreads1039763spreads
steady103510203_steady
streaky14447813streaky
streamy12509483streamy
tardy94720463tar__dy
tared69340053tare_d_
teary85124053t__eary
teddy10489493t__eddy
teredo7310783tere_do
ternary1038343ternary
theory121098363th_eory
thereat104315243therea_t
thereby1534633thereby
thewy146311853th_e_wy
they107223753th_e__y
thrall93810293thr_all
thrash12258363thr_ash
thrave126010273thr_ave
thraw1110515923thr_a_w
thrawn12769423thr_awn
thraws129211103thr_aws
threaders1365743threaders
threadfin1641953threadfin
threadier1354473threadier
threading14107593threading
threaped1454863threaped
threaper1345143threaper
threated1259203threated
threaten1146303threaten
three87526913thre__e
threep115910113thre_ep
threeps12687043threeps
threes97117323thre_es
threnode1255423threnode
thresh12276863thre_sh
threw1117315713thre__w
thrifty1634193thrifty
throat94819753throa_t
throats104612183throats
thrummy1742173thrummy
thruway1643163thruway
tirade7311693tir_ade
tired65228903tire_d_
tiredly1136793tiredly
toady96814343t__oady
toreador944993toreador
tornado845673tornado
torsade837593torsade
trad55630913t_r_ad_
trade65026043t_r_ade
tray77632593t_r_a_y
treacly1237093t_reacly
treaded95014283t_readed
treader84113833t_reader
treadle8310103t_readle
treat56240353t_rea_t
treats64821693t_reats
trebly1138973t_rebly
treed65626733t_reed_
trend64817453t_rend_
trends75513543t_rends
tressy9448553t_ressy
trey77228793t_re__y
triad65217723t_riad_
triads74513533t_riads
turbary1236383turbary
tweaky1634023t_weaky
tweedy13455933t_weedy
tyred95816433tyre_d_
unread73412673unread_
unthread1244603unthread_
unthreads1343633unthreads

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.1561145455.1
2DLD Change Limit1340271346.84319586.0
3Display Results1341340.0462913.0
 (SQL Overall)1786911347.04525364.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.