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

127 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
cheapest153607(None) 
chapes135421872ch_apes_
cheapen14407622cheape_n
cheapens15305942cheapens
cheaper144010582cheape_r
cheapies1539032cheapies_
cheapish1844332cheapish
cheapness1643742cheapness
cheapos14418512cheapos_
cheaps134613682cheap_s_
chewiest16177292chewiest
cleanest10310292cleanest
clearest1038652clearest
heppest14228142_heppest
anapest9311553_anapest
bleakest1436283bleakest
canapes111213083canapes_
capes95441923c__apes_
ceases84427073c_eases_
cepes94424463c_e_pes_
chafes145017913ch_afes_
chalet113825993ch_ale_t
chalets122813473ch_alets
chape125221143ch_ape__
chapeau1435523ch_apeau
chapel134911373ch_ape_l
chapels14429153ch_apels
chaplet14512253ch_aplet
chaplets1556883ch_aplets
chaps125326063ch_ap_s_
chapt125827643ch_ap__t
chares115631803ch_ares_
chariest13315503chariest
chases115128233ch_ases_
chastest1349703chastest
cheap126915943cheap___
cheapened1743783cheapened
cheapener1643773cheapener
cheapie1437563cheap_ie
cheaply1735023cheap_ly
cheapo134810083cheap__o
cheat105732453chea___t
cheated134416343cheate_d
cheater124816953cheate_r
cheaters133613503cheaters
cheats114519543chea_ts_
cheekiest1835703cheekiest
cheeped153410593cheepe_d
cheeper143610743cheepe_r
cheepers15329013cheepers
cheeps135312913cheep_s_
cheeriest1438213cheeriest
cheese113812763che__ese
cheeses123613103cheeses_
cheesiest1436323cheesiest
cheesy14419193che__esy
chegoes1337333chegoes_
chelates132713833chelates_
chemist143615003che_mist
cheques2136863cheques_
chertiest1438793chertiest
chesses124112633chesses_
chest104926143ch___est
chestiest1438313chestiest
chevalet1658123chevale_t
chevalets1743383chevalets
chevies153511443chevies_
chevres15379793chevres_
chevret153310633chevre_t
chevrets16255323chevrets
chicest14209943ch_icest
chiefest1645313chiefest
chillest13259593chillest
chippiest18256803chippiest
chirkest1735383chirkest
chirpiest16286473chirpiest
choicest15226453choicest
chokiest1738723chokiest
choppiest18226373choppiest
chuffest1944183chuffest
cleaves124111623cleaves_
clepes104214623cle_pes_
crapes104727693c_rapes_
creakiest15238593creakiest
creamiest13248933creamiest
creases94020963creases_
creasiest11229943creasiest
creates95225173creates_
creepiest1337063creepiest
crepes105419343cre_pes_
crepiest12310383crepiest
crispest12177373crispest
deadest93014883_deadest
deafest112911513_deafest
dearest83618673_dearest
deepest10310443_deepest
featest102715113_featest
greatest939863greatest
halest94823273_h_alest
headiest123015553_headiest
headrest122910203_headrest
headset11312603_headset
heaped124516903_heape_d
heaper114119523_heape_r
heapers123616673_heapers
heaps105223223_heap_s_
heaves124120303_heaves_
heaviest143210443_heaviest
hempiest1539023_hempiest
herpes115517323_herpes_
hippest14219753_hippest
leanest7415863_leanest
meanest9315703_meanest
nearest73415843_nearest
neatest72516003_neatest
realest73322433_realest
searest73322023_searest
shapes115124943sh_apes_
sharpest1339143sharpest
sheaves134412973sheaves_
sheerest11310083sheerest
shoalest1168913shoalest
steepest1038123steepest
tempest1139223_tempest
therapist1447073therapist
thewiest14196343thewiest
weakest1439003_weakest

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.1701051123.5
2DLD Change Limit1461621278.65616885.6
3Display Results1271270.0462760.9
 (SQL Overall)1786911278.87220141.0
 
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.