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

133 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
fruitiest123738(None) 
crustiest112410052crustiest
faultiest1236092faultiest
flutiest112610882flu_tiest
frettiest1267062frettiest
frostiest1239212frostiest
fruitier1136592fruitie_r
fruitiness1345992fruitiness
fruitless1244162fruitless
fruitlet1146882fruitle_t
fruitlets1243172fruitlets
frumpiest1634542frumpiest
fustiest113014572f_ustiest
runtiest83014512_runtiest
rustiest83116802_rustiest
ruttiest82712662_ruttiest
trustiest9239082trustiest
acuities10312453acuities_
artiest73121993ar__tiest
brainiest11209723brainiest
brattiest1148103brattiest
briniest102812323br_iniest
brushiest14297543brushiest
bustiest102815053_bustiest
craftiest1436913craftiest
cruddiest1334453cruddiest
crudities1247743crudities_
crumbiest1536253crumbiest
crummiest1545563crummiest
draftiest1335943draftiest
driftiest1335943driftiest
druggiest12134973druggiest
drumliest1235433drumliest
dustiest93015073_dustiest
equities17310773equities_
fattiest113514313f_attiest
fatuities1246913fatuities_
feistiest1237073feistiest
ferities111416713ferities_
fittest102510803f__ittest
fixities1838213fixities_
flauntiest1343783flauntiest
flintiest1248433flintiest
flirtiest1236193flirtiest
floatiest1237293floatiest
fluffiest1434093fluffiest
flukiest15248063flu_kiest
flutist102910783flu_ti_st
footiest113514913f_ootiest
fortuities1346323fortuities_
frailest1139493frai_lest
frailties1245853frailties_
freakiest16206693freakiest
frilliest1237113frilliest
fringiest1347603fringiest
friskiest1636233friskiest
frites94922483fr_it_es_
fritzes19329453fr_itzes_
frizziest20294143frizziest
froggiest1434913froggiest
frothiest1537453frothiest
frouziest2143973frouziest
frowsiest1535063frowsiest
frowstiest1643083frowstiest
frowziest2443483frowziest
fruitages1344483fruitages_
fruited11389093fruit_e_d
fruiter10309683fruit_e_r
fruiters11328183fruit_ers
fruitily1445143fruiti_ly
fruiting12229063fruiti_ng
fruition11106103fruiti_on
fruitions12106113fruitions
fruits94512493fruit__s_
fubsiest13258413f_ubsiest
fuggiest13228813f_uggiest
fumiest12312193f_u_miest
funkiest152810973f_unkiest
funniest113010733f_unniest
furmities1447543furmities_
furriest112910793f_urriest
furthest1496863f_urthest
furziest20267783f_urziest
fussiest112910493f_ussiest
fuzziest19235793f_uzziest
goutiest93013883gou_tiest
grainiest10188993grainiest
grimiest11299823gr_imiest
gripiest11289633gr_ipiest
grittiest10176983grittiest
grottiest10147183grottiest
groutiest10147763groutiest
grubbiest1434253grubbiest
gruffiest1634533gruffiest
grumpiest1435023grumpiest
grungiest1135803grungiest
guiltiest1035713_guiltiest
gustiest92914523_gustiest
guttiest92311223_guttiest
jauntiest1635493jauntiest
juiciest1736923_juiciest
lustiest82914493_lustiest
mitiest93520053__mitiest
mustiest103017533_mustiest
nuttiest82312143_nuttiest
poutiest103016793pou_tiest
prettiest1199803prettiest
priciest122112903pr_iciest
priviest132310313pr_iviest
purities10316283purities_
purtiest102414113_purtiest
rainiest81214923_rainiest
rattiest83516113_rattiest
rimiest93215853_r_imiest
ritziest17237843_r_itziest
roiliest8312283_roiliest
rootiest83115593_rootiest
rubiest92914423_ru_biest
ruddiest10278543_ruddiest
ruliest72816433_ru_liest
rummiest12299353_rummiest
runniest82911203_runniest
rushiest113312923_rushiest
sluttiest937343sluttiest
smuttiest1135973smuttiest
squintiest1944993squintiest
tritest7315273tr_it_est
troutiest9127803troutiest
trusties82712853trusties_
tuftiest1138283_tuftiest
vaultiest1234833vaultiest
whitiest14259883_whitiest
wristiest1237753wristiest

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 Filter1786911486410.423422437.4
2DLD Change Limit1486411336.37323323.6
3Display Results1331330.0632111.1
 (SQL Overall)1786911336.85926052.0
 
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.