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

138 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
impeller123608(None) 
impelled1336071impelled
impellers1345101impellers
impellor1242741impellor
compeller1546292compeller
cupeller1256102cupeller
dispeller12146972dispeller
expeller17105782expeller
impaler11298392imp_aler
impeder12438532impe_der
impellent1346442impellent
impellors1352642impellors
repeller103010392repeller
smeller94212782sm_eller
speller95415142_speller
ampler104313303amp__ler
ampullar1253133ampullar
appealer1245743appealer
appellee1246253appellee
appellor1243573appellor
beveller13387663beveller
compelled1646133compelled
compellers1645193compellers
crueller1056453crueller
cupeler1177483cupe_ler
cupelled1365743cupelled
cupellers1374863cupellers
dimplier1336673dimp_lier
dispelled13117563dispelled
dispellers13115443dispellers
dueller8329833_dueller
dweller11297273_dweller
empaler11288353emp_aler
expelled1895873expelled
expellee17116093expellee
expellers18104743expellers
feller94419553__feller
fueller10279963_fueller
gospeller1263743gospeller
grueller935333grueller
heller93322513__heller
iller54821293i___ller
imbalmer1443193imbalmer
immenser1244173immenser
impacter14296573impacter
impairer1244863impairer
impale102811663imp_ale_
impaled12288513imp_aled
impalers12226973imp_alers
impales113311763imp_ales
impanelled1542583impanelled
imparter12357543imparter
impeacher1843093impeacher
impearled1442863impearled
impede11469623impe_de_
impeded13418183impe_ded
impeders13346593impe_ders
impedes124310093impe_des
impel95711773impe_l__
impellents1444363impellents
impelling1436913impelling
impels10389523impe_l_s
impended1435953impended
imperiled1445493imperiled
imperilled1543633imperilled
impinger13315423impinger
impleader1444113impleader
impled113812513imp__led
implied1238623imp_lied
implies11312123imp_lies
implore11176703imp_lore
implorer12125103implorer
importer12308913importer
imposer113310103imp_oser
imposter12288163imposter
impower14247123imp_ower
improper1444533improper
improver1545243improver
impugner13444233impugner
impulse1135113impulse_
impulsed1334003impulsed
impulses1235223impulses
impurer1136483imp_urer
imputer1136533imp_uter
indweller1393013indweller
jeweller1844123jeweller
labeller10248073labeller
lapelled11227083lapelled
leveller11317593leveller
libeller10297433libeller
melder93915813_m_elder
melled95023023_m_elled
melter83520113_m_elter
mewler113510233_m_ewler
micellar12105573micellar
micelle1178343micelle_
micelles1288833micelles
miller84625413_m_iller
modeller1136613modeller
muller83820353_m_uller
pedler93614623__pedler
peeler83517383__peeler
pellet83326553__pellet
pelter83321623__pelter
pimplier1445413pimp_lier
poller83921853__poller
propeller1346623propeller
puller83820813__puller
queller16289293_queller
raveller11339263raveller
repealer103210703repealer
repelled113111583repelled
repellers11278873repellers
reseller83412223reseller
reveller112912183reveller
seller63824593__seller
sheller103515883_sheller
simperer1237173simpe_rer
simpler112910863simp__ler
smaller93410333sm_aller
smelled103511853sm_elled
smellers10329763sm_ellers
smellier1036793sm_ellier
smelter93311913sm_elter
sneller73512843_sneller
spaller92713473_spaller
spelled103714733_spelled
spellers102812753_spellers
spelter94113703_spelter
spiller92914333_spiller
sweller103012463_sweller
teller63519813__teller
timelier1036713tim_elier
umbellar1243643umbellar
umbelled1336273umbelled
umbellet1247073umbellet
yeller94214513__yeller
yodeller1244853yodeller

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 Filter1786911461620.410435831.7
2DLD Change Limit1461621386.17023689.1
3Display Results1381380.0463000.0
 (SQL Overall)1786911386.62626968.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.