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

205 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
shortest1131078(None) 
hottest10411382_hottest
sharpest1339142sharpest
shirtiest1239322shirtiest
shoalest1168912shoalest
shores94830412shor_es_
shortcut1344452shortcut
shorted113614402shorte_d
shorten103511412shorte_n
shortens11288992shortens
shorter103515502shorte_r
shorties11414582shorties_
shortish1437422shortish
shortlist1246682shortlist
shortness1236732shortness
shorts95321742short_s_
shotes95321912sho_tes_
showiest1438782showiest
smartest10310182smartest
softest10310602s_oftest
sorest65028002s_or_est
sportiest111711022sportiest
stoutest837612stoutest
alertest8310173alertest
chariest13315503chariest
chartist131112133chartist
chastest1349703chastest
chertiest1438793chertiest
chirkest1735383chirkest
choicest15226453choicest
chokiest1738723chokiest
chores114828023chor_es_
chorten122811303chorte_n
chortens13308793chortens
chortles133611323chortles_
contest93523233_contest
curtest9713963_curtest
footrest11308853footrest
forest94926743_for_est
fortes95327183_fortes_
ghostiest1336543ghostiest
goriest82218743_goriest
hardest113118413_hardest
harvest132112753_harvest
hoariest11312883_hoariest
hoarsest1137133_hoarsest
hokiest144114243_hokiest
holiest104319623_holiest
homiest124116633_homiest
honest94822423_ho_nest
hootiest113115643_hootiest
hordes104921633_hordes_
hornet94926433_horne_t
hornets104113553_hornets
horniest112814043_horniest
hornist102314823_hornist
horrent10313553_horrent
horses94729343_horses_
horsiest112513263_horsiest
horst85833513_hor__st
horstes104516113_horstes_
hostess103210243_hostess
mooriest102812723mooriest
mostest9314793_mostest
obtest81213013__obtest
oftest91212003__oftest
peartest10311303peartest
pertest9317043_pertest
phattest1336913phattest
phoniest132811533phoniest
phorates13413043phorates_
phoresy1534653phor_esy
poorest9312773poor_est
portent93619643_portent
protest9317533pro_test
saltest71916513s_altest
savoriest1246613savoriest
scantest101710183scantest
scarcest12169173scarcest
scariest101615943scariest
scores84725923scor_es_
searest73322023sear_est
secretest1147033secretest
sedatest9249393sedatest
serest64831613s_er_est
shadiest121711273shadiest
shakiest151910933shakiest
shaliest111415053shaliest
shares95236413shar_es_
sheerest11310083sheerest
sherbert1348793sherbert
sherbet12311383sherbe_t
sherbets1335213sherbets
shiest95821523sh__iest
shiftiest1537363shiftiest
shiniest113212493shiniest
shires95225573shir_es_
shirtless12266413shirtless
shirts94918343shirt_s_
shittiest1238333shittiest
shoaliest1238503shoaliest
shoats94117083shoat_s_
shoddiest1434753shoddiest
shoeless1137803shoeless
shoes85429663sho__es_
shooter103013993shoote_r
shooters112811583shooters
shootout1146623shootout
shoots94619363shoot_s_
shoppes143411393shoppes_
shorans102812413shorans_
shore85432653shor_e__
shored105723653shor_e_d
shoreless1236633shoreless
shorls94516203shor_ls_
short85040533shor___t
shortage1236313shortage
shortages1336513shortages_
shortcuts1442513shortcuts
shortened1345663shortened
shortener1245773shortener
shorthead1644473shorthead
shortia1048193short_ia
shortias1148093shortias
shortie10411343short_ie
shorting122514803shorting
shortlists1344083shortlists
shortly13387573short_ly
shortstop1452153short_stop
shorty124313203short__y
shote85526103sho_te__
shots84730853sho_t_s_
shott85332193sho_t__t
shotted113912403shotte_d
shotten10288463shotte_n
shotts93614703sho_tts_
shouldest1344143shouldest
shouldst1243393shouldst
shouted113911553shoute_d
shouter103213083shoute_r
shouters113510623shouters
shouts94017723shout_s_
shoves124919423sho_ves_
shutes93518223sh_utes_
shyest125511833sh__yest
skorts104211303skort_s_
slowest10168713slo_west
smokiest1437883smokiest
smoothest14215773smoothest
snootiest9178753snootiest
snores64324323snor_es_
snorted83813493snorte_d
snorter74412663snorte_r
snorters83410583snorters
snorts64116503snort_s_
snottiest9167973snottiest
snoutiest9178253snoutiest
snowiest1138143snowiest
soonest7415593s_oonest
soothest113312243soothest
sootiest84016753sootiest
sorbent92915243s_orbent
sorbet83924083s_orbe_t
sorbets93012513s_orbets
sores55454283s_or_es_
sorites73825243s_orites_
sorriest8413883sorriest
sorted74523713s_orte_d
sorter64425093s_orte_r
sorters74221133s_orters
sorties74126403s_orties_
sorts54536663s_ort_s_
sourest7515713s_ourest
sparest94616423spar_est
sparsest1048813sparsest
spheriest1438373spheriest
spiriest102513453spiriest
spores84726613spor_es_
sported104015433sporte_d
sporter93616553sporte_r
sporters103714063sporters
sports84619183sport_s_
spottiest11177683spottiest
spriest92718643s_priest
spryest12247813s_pryest
starkest1239723starkest
sternest8314433sternest
stoniest8413543stoniest
stores65533663stor_es_
stories7324273stories_
stormiest1137003stormiest
subtest9513963s_ubtest
surest65026763s_ur_est
sveltest1135873sveltest
sweetest1137173sweetest
swiftest1434353swiftest
tartest72517533_tartest
thorites11312393thorites_
thorniest1236483thorniest
thorpes125010353thorpes_
tortes64826053_tortes_
whitest133710113wh_itest
whores125617103whor_es_
whortles14306743whortles_
whorts125111433whort_s_

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.440406115.9
2DLD Change Limit1461622056.54622328.4
3Display Results2052050.0762697.4
 (SQL Overall)1786912057.06225303.2
 
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.