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

117 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
smelliest113660(None) 
shelliest1238021shelliest
mealiest102215972_mealiest
seemliest1145622seemliest
shelviest1535002shelviest
silliest84017102s_illiest
smallest1039402small_est
smeariest1138112smeariest
smellier1036792smellie_r
snellest839492snell_est
steeliest939642steeliest
stilliest939222stilliest
swellest1137662swell_est
bellies94023723_bellies_
bulliest104314503_bulliest
cellist9314423_celli_st
chilliest14358913chilliest
comeliest13410033come_liest
dellies83622213_dellies_
duellist986333duelli_st
eeliest73516473__eeliest
elmiest9310743__elmiest
emollient1155103emollient
fellest10313753_fell_est
fellies104119743_fellies_
frilliest1237113frilliest
hilliest113914113_hilliest
homeliest1448553home_liest
jellies143816533_jellies_
jolliest152910363_jolliest
kellies113516853_kellies_
malmiest123211023_malmiest
maltiest102916193_maltiest
manliest102314943_manliest
marliest102415183_marliest
mealies92821933_mealies_
measliest1147173_measliest
meatiest102816793_meatiest
mellowest1445123_mellowest
merriest10311473_merriest
meshiest132911033_meshiest
messiest103112423_messiest
milkiest142911083_milkiest
miltiest103015173_miltiest
moldiest11249693_moldiest
mollies93420233_mollies_
motliest10310773_motliest
nellies73418723_nellies_
niellist848353nielli_st
palliest102814633_palliest
sallies73227813s_allies_
saltiest83117713s_altiest
scaliest101714393s_caliest
seamiest102715413s_eamiest
sedgiest10259763s_edgiest
seediest92714053s_eediest
seepiest102412623s_eepiest
selkies113513353s_elkies_
selles64426983s_ell_es_
sexiest142112223s_e_xiest
shaliest111415053s_haliest
sheeniest12158353sheeniest
shellier1138393shellie_r
shelties111111383shelties_
shoaliest1238503shoaliest
sickliest1547523sickliest
silkiest123212853s_ilkiest
sillies73425083s_illies_
siltiest83515613s_iltiest
sleaziest1836053sleaziest
sleekiest1336063sleekiest
sleepiest1136713sleepiest
sleetiest938553sleetiest
sliest66621953s___liest
smallish1346573smalli_sh
smallness1174513smallness
smarmiest1335903smarmiest
smelled103511853smell_e_d
smeller94212783smell_e_r
smellers10329763smell_ers
smelling113712723smelli_ng
smells83914743smell__s_
smirkiest1535193smirkiest
smoggiest1334463smoggiest
smokiest1437883sm_okiest
smudgiest1334373smudgiest
smuttiest1135973smuttiest
snarliest91810203snarliest
sneakiest13176833sneakiest
sneeriest939313sneeriest
sneeziest1845153sneeziest
speediest1257463speediest
spendiest1237523spendiest
squalliest1944133squalliest
stalkiest1347903stalkiest
steadiest1038513steadiest
steamiest1138403steamiest
steelies8312553steelies_
stellites938123stellites_
stemmiest1335143stemmiest
stillest8311073still_est
studliest1036573studliest
sulkiest124212503s_ulkiest
sullies74122233s_ullies_
surliest82416913s_urliest
sveltest1135873sve_ltest
sweatiest1238413sweatiest
sweepiest1435673sweepiest
sweltriest1343283sweltriest
swirliest1236293swirliest
tellies73820503_tellies_
timeliest1147233time_liest
vealiest112513203_vealiest
wellies103719073_wellies_
whelkiest1943963whelkiest
wieldiest1334803wieldiest
woolliest1235853woolliest

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.1561145455.1
2DLD Change Limit1486411176.64022385.7
3Display Results1171170.0462543.5
 (SQL Overall)1786911176.84226116.8
 
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.