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

126 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
phattest133691(None) 
attest62618612__attest
chastest1349702chastest
chattiest1448202chattiest
coattest1038862coattest
fattest102913062_fattest
flattest1138712flattest
hottest10411382_hottest
peartest10311302peartest
peatiest103118802peatiest
phantast1346922phantast
phatter123810202phatte_r
platiest103216082platiest
posttest10410232posttest
wattest102412152_wattest
aptest82917513__aptest
attent62818323__attent
attests7278813__attests
battiest104115553_battiest
brattiest1148103brattiest
cattiest103016333_cattiest
chariest13315503chariest
chartist131112133chartist
chatted133411893chatte_d
chattel12388893chatte_l
chattels13286793chattels
chatter124416643chatte_r
chatters134213953chatters
chattery16357273chattery
coattests1143463coattests
daftest11248943_daftest
exactest1745453exactest
fastest102413723_fastest
fattiest113514313_fattiest
featest102715113fea_test
fittest102510803_fittest
gnattiest1035383gnattiest
haddest122711993_haddest
halest94823273_ha_lest
hardest113118413_hardest
harvest132112753_harvest
hastes95727073_hastes_
hastiest112916493_hastiest
hates86742573_ha_tes_
hatless103813443_hatless
hatted104921513_hatte_d
hatter94724873_hatte_r
hatters104221523_hatters
haziest193313003_haziest
iratest7312483ira_test
latest63822703_la_test
lattes65324203_lattes_
matiest92522453_matiest
mattes85624533_mattes_
meatiest102816793meatiest
nattiest83215353_nattiest
neatest72516003nea_test
paciest112917803p_aciest
palest83926223p_a_lest
paliest93021603p_aliest
pastes85233913p_astes_
pastiest103319543pastiest
patent84524923p_a_tent
pates76047893p_a_tes_
patient9617073p_atient
patness92912283p_atness
patted94724683p_atte_d
pattee84323383p_atte_e
patten84418193p_atte_n
pattens95414923p_attens
patter84628263p_atte_r
pattern93712053p_attern
patters94825193p_atters
patties93425143p_atties_
peakiest143512993peakiest
pertest9317043p_ertest
pestiest103018413pestiest
pettiest103113963pettiest
phages125213513pha_ges_
phallist1338983phallist
phantasm1554133phantasm
phantasts1443953phantasts
phantasy1643463phantasy
phases114618403pha_ses_
phoniest132811533phoniest
photoset13414283photoset
plainest10313613plainest
plates85432243pla_tes_
platies93722543platies_
platted103614263platte_d
platter93917413platte_r
platters103415283platters
plottiest11287833plottiest
politest10312943politest
posttests1144973posttests
pottiest102815973pottiest
poutiest103016793poutiest
prates84633163pra_tes_
prattles10189403prattles_
pretest9517633p_retest
prettiest1199803prettiest
protest9317533p_rotest
purtiest102414113purtiest
rattiest83516113_rattiest
saltest71916513_saltest
scantest101710183scantest
scattiest11268363scattiest
shadiest121711273shadiest
shakiest151910933shakiest
shaliest111415053shaliest
sharpest1339143sharpest
shatter103615703shatte_r
shatters113313913shatters
shittiest1238333shittiest
shortest11310783shortest
slatiest82616263slatiest
smartest10310183smartest
squattest1844613squattest
tartest72517533_tartest
tattiest83415383_tattiest
tautest72612443_tautest
vastest102911513_vastest
wettest10239363_wettest
whatness1435093whatness
whitest133710113wh_itest
whitiest14259883whitiest

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 Filter1786911461620.420425454.8
2DLD Change Limit1461621266.69021847.8
3Display Results1261260.0462739.1
 (SQL Overall)1786911267.15624970.8
 
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.