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

251 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
daffiest153783(None) 
draffiest1644351draffiest
baffies153612942baffies_
buffiest1657552buffiest
chaffiest2045402chaffiest
daffier1457832daffie_r
daffiness1634842daffiness
daftest11248942da_ftest
dandiest103415032dandiest
dashiest12311112dashiest
daubiest1138232daubiest
deffest14308802deff_est
draftiest1335942draftiest
huffiest1757192huffiest
iffiest1337952_iffiest
miffiest1637122miffiest
puffiest1647312puffiest
taffies133012692taffies_
waffies163611442waffies_
waffliest1844222waffliest
achiest12315183_achiest
aeriest73924053_aeriest
affect1448903_aff_ect
affiant1348433_affiant
affines1339483_affines_
affixes2035503_affixes_
afforest1446333_afforest
airiest74221013_airiest
artiest73121993_artiest
ashiest10313953_ashiest
babiest114414753ba_biest
baffles153710683baffles_
baggiest123011753baggiest
balkiest144112453balkiest
balmiest124110993balmiest
barkiest144115153barkiest
barmiest125212783barmiest
barniest104815053barniest
battiest104115553battiest
bawdiest14398673bawdiest
beefiest13269013beefiest
biffies152710853biffies_
buffest15298633buff_est
cagiest102916433ca_giest
cakiest133215663ca_kiest
campiest142212133campiest
canniest10313363canniest
cattiest103016333cattiest
chuffiest2044393chuffiest
cliffiest1743943cliffiest
comfiest1539133comfiest
craftiest1436913craftiest
dadaist9310103dadai_st
daddies103414943daddies_
daffed14429493daff_e_d
daffily1735133daffi_ly
daffing15369733daffi_ng
daffs125116423daff__s_
daftness1235533daftness
dailies84219263dailies_
daintiest1039153daintiest
dairies84217733dairies_
daisies84217093daisies_
dallies84023193dallies_
damndest1276003damndest
dampest12411043da_mpest
dandies94121443dandies_
dangliest1137173dangliest
dankest122611673da_nkest
darbies104216983darbies_
darkest122512623da_rkest
darkies124015753darkies_
darkliest1435163darkliest
darndest1067223darndest
dassies84418663dassies_
dauties83315763dauties_
davies105020513da_vies_
dawties113312703dawties_
dayflies1534463dayflies_
deadliest1138183deadliest
deafest112911513deaf_est
deediest102912253deediest
defies104624053d_efies_
deforest1238793deforest
deftest112611713d_eftest
deifies113317453deifies_
dewiest11312343d_ewiest
diciest103316523d_iciest
dickiest153412503dickiest
dictiest113212783dictiest
diffident1764223diffident
dingiest102915363dingiest
dinkiest133812873dinkiest
dippiest132511133dippiest
dirtiest93014203dirtiest
dishiest12313683dishiest
ditsiest92111323ditsiest
ditziest18218473ditziest
dizziest17266723dizziest
dodgiest11308713dodgiest
doggiest113410523doggiest
doomiest112910453doomiest
dopiest103315993d_opiest
dorkiest133111253dorkiest
dotiest83717453d_otiest
dottiest92611393dottiest
dowdiest13328953dowdiest
downiest122710603downiest
doziest174012473d_oziest
draffier1574323draffie_r
draffish1844553draffi_sh
draggiest12126413draggiest
drawliest13166243drawliest
driest74722753d__riest
driftiest1335943driftiest
duckiest153211863duckiest
duffles14308913duffles_
dumpiest1338743dumpiest
dungiest102810743dungiest
duskiest133710083duskiest
dustiest93015073dustiest
dwarfest1543473dwarf_est
earliest82415243earliest
easiest72318773ea_siest
faddiest1338113faddiest
faggiest132910183faggiest
fanciest133612713fanciest
fattiest113514313fattiest
fawniest14287443fawniest
fliest94718423__fliest
fluffiest1434083fluffiest
gabbiest1337273gabbiest
gabfest1336453gabf_est
gaffes134811103gaff_es_
gamiest102816223ga_miest
gammiest13339323gammiest
gappiest13259473gappiest
gassiest93212523gassiest
gaudiest1039393gaudiest
gauziest1836233gauziest
gawkiest16327313gawkiest
goofiest12289393goofiest
gruffiest1634523gruffiest
gulfiest1247943gulfiest
haffet15311703haff_e_t
haffets1636053haff_ets
haffit1538533haffi__t
haffits1636193haffits_
hairiest11612463hairiest
hammiest152610003hammiest
handiest123417773handiest
happiest152411673happiest
hardiest123416333hardiest
hastiest112916493hastiest
haziest193313003ha_ziest
heftiest1439183heftiest
jaggiest17289323jaggiest
jammiest19307203jammiest
jazziest2333813jazziest
jiffies20327473jiffies_
kaffirs17325553kaffirs_
laciest93819033la_ciest
lakiest113517263la_kiest
lambiest122410183lambiest
lankiest122912493lankiest
lardiest93813883lardiest
larkiest123713313larkiest
lathiest11312653lathiest
laziest163814473la_ziest
leafiest113410883leafiest
loftiest1139083loftiest
maffias15327283maffias_
malmiest123211023malmiest
maltiest102916193maltiest
mangiest112815903mangiest
manifest1339503manifest
manliest102314943manliest
marliest102415183marliest
massiest103314423massiest
matiest92522453ma_tiest
maziest183613873ma_ziest
naggiest102610013naggiest
nappiest122510883nappiest
nastiest83615953nastiest
nattiest83215353nattiest
niftiest112910063niftiest
oakiest112913923oa_kiest
paciest112917803pa_ciest
paliest93021603pa_liest
palliest102814633palliest
palmiest123212023palmiest
pappiest112611113pappiest
pastiest103319543pastiest
pawkiest17277883pawkiest
raciest92820013ra_ciest
raffias13237713raffias_
raffish1658843raffi_sh
raffles133611843raffles_
rainiest81214923rainiest
rammiest12299933rammiest
randiest93418773randiest
rangiest93115983rangiest
raspiest10311273raspiest
rattiest83516113rattiest
reefiest112811483reefiest
ruffliest1554483ruffliest
safest95016603sa_f_est
saggiest102812713saggiest
sagiest82617983sa_giest
saltiest83117713saltiest
sandiest93218683sandiest
sappiest122612573sappiest
sarkiest123615063sarkiest
sassiest83413613sassiest
sauciest10310963sauciest
savviest1435983savviest
sniffiest15235993sniffiest
snuffiest15246043snuffiest
spiffiest17235643spiffiest
stuffiest15235943stuffiest
surfiest112414423surfiest
tackiest143112433tackiest
taffias13377413taffias_
talkiest123611223talkiest
tangiest92915223tangiest
tardiest93515243tardiest
tarriest83215003tarriest
tartiest82718313tartiest
tastiest83216633tastiest
tattiest83415383tattiest
tawniest11279343tawniest
toffies133210213toffies_
tuftiest1138273tuftiest
turfiest112410123turfiest
vampiest15237643vampiest
vastiest112713073vastiest
wackiest172610273wackiest
waffie15338563waffie__
waffles16329983waffles_
waniest103819113wa_niest
wariest105122503wa_riest
wartiest113614643wartiest
washiest14310403washiest
waspiest1338813waspiest
waviest134513073wa_viest
waxiest173510883wa_xiest
wiftiest14279173wiftiest
zaffirs22375663zaffirs_
zaffres22324993zaffres_
zaniest163214773za_niest
zappiest21228023zappiest

Search took 9 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.233766914.2
2DLD Change Limit1461622517.94018408.3
3Display Results2512510.0932698.9
 (SQL Overall)1786912518.26621617.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.