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

200 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
smellier103679(None) 
shellier1138391shellier
smeller94212791smell_er
mealier93015902_mealier
millier93716702_millier
sallier73320422s_allier
seemlier1035192seemlier
seller63824602s_ell_er
sheller103515892shell_er
shelvier1464912shelvier
sillier74017592s_illier
smaller93410332small_er
smearier1036952smearier
smelled103511862smell_ed
smellers10329772smell_ers
smelliest1136602smelliest
smelling113712722smelling
smelter93311912sme_lter
sneller73512852snell_er
speller95415152spell_er
steelier839192steelier
stillier868822stillier
sweller103012472swell_er
atelier7311623ate_lier
belier84423563_be_lier
bellied104314073_bellied
bellies94023723_bellies
bullier94116433_bullier
chillier13328423chillier
collier93618153_collier
comelier12310653come_lier
dallier84215373_dallier
dellies83622213_dellies
dueller8329833duell_er
dweller11297273dwell_er
eelier64216463__eelier
elmier839813__elmier
feller94419553_fell_er
fellies104119743_fellies
frillier1136513frillier
fueller10279963fuell_er
heller93322513_hell_er
hillier103413963_hillier
homelier1338983home_lier
impeller1236083impell_er
jellied15419223_jellied
jellies143816533_jellies
jollier142911003_jollier
kellies113516853_kellies
malmier113611953_malmier
maltier93015483_maltier
manlier92414023_manlier
marlier92614773_marlier
mealie82519813_mealie_
mealies92821933_mealies
measlier1036013_measlier
meatier93214613_meatier
melder93915813_me_lder
melled95023023_mell_ed
melling102822623_melling
mellower13167403_mellower
melter83520113_me_lter
merrier92612303_merrier
meshier123410853_meshier
messier93412923_messier
metier83517693_me_tier
mewler113510233_mewl_er
milkier133411163_milkier
miller84625413_mill_er
milliers102611903_milliers
milliner102811863_milliner
miltier93214963_miltier
moldier103110033_moldier
mollie83517103_mollie_
mollies93420233_mollies
motlier92010583_motlier
muller83820353_mull_er
nellie63614813_nellie_
nellies73418723_nellies
pallier94417163_pallier
queller16289293quell_er
rallier73816273_rallier
relier65826183_re_lier
replier94214973_replier
sallied83316953s_allied
salliers83613343s_alliers
sallies73227813s_allies
saltier74318633s_altier
scalier94316913s_calier
sculler99812153scull_er
sealer63928963s_eal_er
seamier93114633s_eamier
sedgier9399053s_edgier
seedier83513633s_eedier
seepier92912013s_eepier
selkie102811693s_elkie_
selkies113513353s_elkies
selle54428313s_ell_e_
sellers73721323s_ell_ers
selles64426983s_ell_es
selling83225833s_elling
seltzer1635213s_eltzer
sexier13310683s_e_xier
shalier103116423s_halier
sheenier11167423sheenier
shelled113815093shell_ed
shellers112812583shell_ers
shellfire1542513shellfire
shelliest1238033shelliest
shelling123515213shelling
shelter103214963she_lter
sheltie10109913sheltie_
shelties111111383shelties
shelver134211063she_lver
shoalier1137073shoalier
sicklier1457213sicklier
silkier114411643s_ilkier
siller64026063s_ill_er
sillies73425083s_illies
siltier73413863s_iltier
skelter113610003ske_lter
sleazier1735123sleazier
sleekier1245573sleekier
sleepier1036783sleepier
sleetier837883sleetier
slier54827243s___lier
smallish1346573smallish
smarmier1235033smarmier
smearer94110403sme_arer
smell74916233smell___
smells83914743smell__s
smelly114110363smell__y
smelted10399093sme_lted
smelters103310513sme_lters
smeltery13274963sme_ltery
smelting11339713smelting
smiler83916683sm_il_er
smirkier1444433smirkier
smoggier1243973smoggier
smokier1356703sm_okier
smolder10327753sm_older
smoulder1133443smoulder
smudgier1233753smudgier
smuttier1035213smuttier
snarlier8278183snarlier
sneakier1245143sneakier
sneerier878103sneerier
sneezier1774333sneezier
snelled83313053snell_ed
snelling93913563snelling
soldier82812153s_oldier
sommelier1343643sommelier
spaller92713473spall_er
speedier1146623speedier
spelled103714743spell_ed
spellers102812763spell_ers
spelling113315233spelling
spelter94113703spe_lter
spendier1147143spendier
spiller92914333spill_er
squallier1844363squallier
stalkier1257073stalkier
steadier937313steadier
stealer72913983steal_er
steamier1048303steamier
steelie7310213steelie_
steelies8312553steelies
stellar72610433stell_ar
stellify1443883stellify
stellite839533stellite
stellites938123stellites
stemmier1245253stemmier
stiller73414303still_er
studlier935473studlier
sulkier113811963s_ulkier
sullied83714483s_ullied
sullies74122233s_ullies
supplier1246603supplier
surlier72915443s_urlier
svelter10359673sve_lter
sweatier1147033sweatier
sweepier1355493sweepier
swelled113211703swell_ed
swelling123212753swelling
swelter103711173swe_lter
sweltrier1242993sweltrier
swiller103211663swill_er
swirlier1135213swirlier
tallier72817213_tallier
teller63519823_tell_er
tellies73820503_tellies
timelier1036713time_lier
umbellifer1751813umbellifer
vealier102712173_vealier
wellie92814913_wellie_
wellies103719073_wellies
whelkier1833253whelkier
wieldier1234283wieldier
woollier1155433woollier
yeller94214513_yell_er

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.423422437.4
2DLD Change Limit1461622007.47019566.5
3Display Results2002000.0762631.6
 (SQL Overall)1786912007.96922423.3
 
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.