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

171 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
smeariest113812(None) 
bleariest1158852bleariest
dreariest10229122dreariest
leariest83117852_leariest
mealiest102215972_mealiest
meatiest102816792_meatiest
merriest10311482_merriest
scariest101615952s_cariest
seamiest102715422s_eamiest
searest73322022s_ear_est
sleaziest1836062sleaziest
smarmiest1335912sm_armiest
smartest10310182sm_artest
smearier1036952smearie_r
smelliest1136602smelliest
sneakiest13176842sneakiest
sneeriest939312sneeriest
steadiest1038522steadiest
steamiest1138412steamiest
sugariest1038142sugariest
sweatiest1238422sweatiest
teariest82417262_teariest
weariest112914792_weariest
aeriest73924053_ae_riest
ambaries123312383ambaries_
beadiest113815533_beadiest
beakiest143313463_beakiest
beamiest123212763_beamiest
beeriest104013403_beeriest
chariest13315513_chariest
cheeriest1438213cheeriest
clearest1038653clear_est
creakiest15238593creakiest
creamiest13248933creamiest
creasiest11229943creasiest
dearest83618673_dear_est
dearies83526273_dearies_
dreamiest12227223dreamiest
drearies92313413drearies_
earliest82415243__earliest
earnest7318733__earnest
easiest72318773__easiest
eeriest73620673__eeriest
emeries91620023eme_ries_
fieriest112112243fie_riest
freakiest16206693freakiest
glariest92012533_glariest
gleamiest1235313gleamiest
greasiest10208563greasiest
headiest123015553_headiest
heartiest12311103_heartiest
heaviest143210443_heaviest
hoariest11312883_hoariest
leadiest93314993_leadiest
leafiest113410893_leafiest
leakiest123212803_leakiest
leaviest112910823_leaviest
leeriest83112883_leeriest
marliest102415183_m_arliest
matiest92522453_m_atiest
maziest183613873_m_aziest
mealies92821933_mealies_
meanest9315703_mea_nest
meanies93620743_meanies_
measliest1147173_measliest
merest84725113_me_r_est
meshiest132911033_meshiest
messiest103112423_messiest
metrist9317063_metri_st
miriest93619823_m_iriest
mooriest102812723_mooriest
nearest73415843_near_est
nearliest949363_nearliest
oneriest8313443one_riest
peakiest143513003_peakiest
pearliest1139363_pearliest
peartest10311303_peartest
peatiest103118813_peatiest
queasiest1844313queasiest
queaziest2743243queaziest
readiest93719043_readiest
rearrest8311603_rearrest
sagiest82617993s__agiest
salaries8319593salaries_
sarkiest123615073s__arkiest
savoriest1246623savoriest
scaliest101714403s_caliest
scarcest12169173s_carcest
scarriest11188403scarriest
scenarist1147823scenari_st
sedgiest10259763s_edgiest
seediest92714053s_eediest
seemliest1145623seemliest
seepiest102412633s_eepiest
serest64831613s_e_r_est
series64540973s_e_ries_
serries73925353s_erries_
sexiest142112223s_e_xiest
shadiest121711283s_hadiest
shakiest151910943s_hakiest
shaliest111415063s_haliest
sharpest1339153s_harpest
sheeniest12158363sheeniest
sheerest11310083sheer_est
shelliest1238033shelliest
shelviest1535013shelviest
sherries111812893sherries_
shoaliest1238513shoaliest
sitarist8315283sitari_st
skerries12168673skerries_
slatiest82616273s_latiest
sleekiest1336073sleekiest
sleepiest1136723sleepiest
sleetiest938563sleetiest
smallest1039403sm_allest
smarties10312873sm_arties_
smearcase1342533smearcase
smeared104510623smear_e_d
smearer94110403smear_e_r
smearers10308623smear_ers
smearing113511753smeari_ng
smears84714433smear__s_
smirkiest1535193smirkiest
smoggiest1334463smoggiest
smokiest1437883sm_okiest
smudgiest1334373smudgiest
smuttiest1135973smuttiest
snakiest122110553s_nakiest
snarkiest13207643s_narkiest
snarliest91810213s_narliest
sneeziest1845153sneeziest
soapiest102412853s_oapiest
sorriest8413883s_orriest
spaciest122310903s_paciest
sparest94616433s_par_est
sparkiest15188103s_parkiest
sparriest11198793sparriest
sparsest1048823s_parsest
speediest1257473speediest
spendiest1237533spendiest
spheriest1438383spheriest
spiriest102513463s_piriest
spriest92718653s__priest
squarest17338223squar_est
squeakiest2342793squeakiest
stagiest91613413s_tagiest
starkest1239723s_tarkest
starriest9159773starriest
steadies9311123steadies_
stearines9311283stearines_
stearins8312143stearins_
steeliest939643steeliest
stemmiest1335143stemmiest
sternest8314433ste_rnest
strawiest1237223strawiest
streakiest1444773streakiest
streamiest1245123streamiest
sudaries9312753sudaries_
sultriest938653sultriest
summaries13118183summaries_
summarist13116763summari_st
summeriest1476083summeriest
sweepiest1435683sweepiest
sweltriest1343283sweltriest
tweakiest1634053tweakiest
uneasiest946563uneasiest
unwariest1246033unwariest
vealiest112513203_vealiest
veriest103719133_ve_riest
wariest105122503__wariest
wearies103020223_wearies_

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.420425454.8
2DLD Change Limit1486411716.42323142.0
3Display Results1711710.0762250.0
 (SQL Overall)1786911716.91925826.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.