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

125 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
cheesiest143632(None) 
cheekiest1835701cheekiest
cheeriest1438211cheeriest
cheeses123613102chees_es_
cheesier1335962cheesie_r
cheesiness1544732cheesiness
chertiest1438792chertiest
chestiest1438312chestiest
chewiest16177292ch_ewiest
choosiest1437322choosiest
creasiest11229942creasiest
creepiest1337062creepiest
cutesiest1146102cutesiest
sheeniest12158352sheeniest
wheeziest2443662wheeziest
beefiest13269013_beefiest
beeriest104013403_beeriest
bheesties1443923bheesties_
bluesiest1135693bluesiest
breeziest2035063breeziest
chaffiest2045413chaffiest
chalkiest1837083chalkiest
chanciest1638373chanciest
chariest13315503ch_ariest
charriest1438253charriest
chastest1349703ch_astest
chattiest1448203chattiest
cheapest1536073ch_eapest
cheapies1539033cheapies_
cheekier1735103cheekie_r
cheekiness1944043cheekiness
cheekless1873883cheekless
cheerier1348003cheerie_r
cheeriness1545533cheeriness
cheerios13317583cheerios_
cheerless1495293cheerless
cheese113812763chees_e__
cheesed133910683chees_e_d
cheesily1654413cheesi_ly
cheesing14349413cheesi_ng
chemises153211983chemises_
chemist143615003ch_emi_st
cherries131812983cherries_
chesses124112633ch_esses_
chevies153511443ch_evies_
chichiest1936343chichiest
chiefest1645313chie_fest
chilliest14358913chilliest
chinkiest1867023chinkiest
chippiest18256803chippiest
chirpiest16286473chirpiest
chokiest1738723ch_okiest
choppiest18226373choppiest
chromiest1637783chromiest
chubbiest1843753chubbiest
chuffiest2044403chuffiest
chummiest1834643chummiest
chunkiest1835263chunkiest
classiest11309543classiest
clumsiest1335393clumsiest
comeliest13410033comeliest
cosiest93819853c__osiest
creakiest15238593creakiest
creamiest13248933creamiest
creepies1239613creepies_
creeses93914623crees_es_
creeshes1336953creeshes_
crepiest12310383c_repiest
deediest102912253_deediest
dressiest1036823dressiest
dweebiest1542663dweebiest
easiest72318773__easiest
eeliest73516473__eeliest
eeriest73620673__eeriest
fleeciest1434873fleeciest
geekiest13257863_geekiest
gleetiest1035913gleetiest
greasiest10208563greasiest
greediest1147553greediest
greeniest1039033greeniest
headiest123015553_headiest
heaviest143210443_heaviest
hedgiest13298133_hedgiest
heftiest1439183_heftiest
hempiest1539023_hempiest
herbiest1339993_herbiest
heresies11312693_heresies_
hissiest112911093_hissiest
horsiest112513263_horsiest
kneesies1245543kneesies_
leeriest83112883_leeriest
messiest103112423_messiest
neediest92611303_neediest
newsiest11107483_newsiest
queasiest1844313queasiest
reediest92815423_reediest
reefiest112811483_reefiest
reekiest122711313_reekiest
rheumiest1442863rheumiest
seediest92714053_seediest
seepiest102412623_seepiest
sheenies111411543sheenies_
sheerest11310083shee_rest
shelliest1238023shelliest
shelviest1535003shelviest
sleekiest1336063sleekiest
sleepiest1136713sleepiest
sleetiest938553sleetiest
sneeriest939313sneeriest
sneeziest1845153sneeziest
speediest1257463speediest
steeliest939643steeliest
sweepiest1435673sweepiest
teeniest82112413_teeniest
teensiest945823teensiest
thewiest14196343th_ewiest
tressiest937883tressiest
tweediest1344273tweediest
uneasiest946563uneasiest
weediest122311133_weediest
weeniest112411213_weeniest
weensiest1244743weensiest
weepiest13219473_weepiest
wheelies1437863wheelies_
whelkiest1943963whelkiest

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 Filter1786911486410.1561145455.1
2DLD Change Limit1486411257.56319653.7
3Display Results1251250.0631984.1
 (SQL Overall)1786911257.78222962.1
 
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.