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

260 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
impaler1129839(None) 
empaler11288351empaler
impale102811661impale_
impaled12288511impaled
impalers12226971impalers
impales113311761impales
ampler104313302amp_ler
empale102611262empale_
empaled12288952empaled
empalers12226742empalers
empales112411432empales
imager9108122im_ager
imbalmer1443192imbalmer
impacter14296572impacter
impair1036002impa_ir
impairer1244862impairer
impala10256932impal_a
impalas11236952impalas
impanel1137092impanel
imparter12357542imparter
impeder12438532impeder
impeller1236082impeller
impled113812512imp_led
imposer113310102imposer
impower14247122impower
impurer1136482impurer
imputer1136532imputer
inhaler1068052inhaler
paler75436932__paler
simpler112910862simp_ler
ambler104916453am_bler
ample94720303amp_le_
ampule10710613ampule_
ampules1189433ampules
appealer1245743appealer
baler75635273__baler
capabler1435353capabler
coaler84121713_coaler
comparer143611363comparer
compiler1438373compiler
cupeler1177483cupeler
cymbaler1743113cymbaler
dealer74122143_dealer
dialer74315433_dialer
dimple113512793dimp_le_
dimpled132810303dimp_led
dimples122813213dimp_les
dimplier1336673dimplier
dismaler1137903dismaler
embalmer1444063embalmer
empanel1145963empanel
empower14217033empower
emptier1187603emptier
espalier1036363espalier
gimbaled14104173gimbaled
gimpier12247943gimp_ier
haler85033523__haler
healer94221803_healer
idler65015663i__dler
iller54821293i__ller
image81411293im_age_
imaged1097763im_aged
imagers10107763im_agers
imagery13124203im_agery
images91411463im_ages
imaret81121233im_aret
imbalm1246323imbal_m
imbalmed1543293imbalmed
imbalmers1543103imbalmers
imbalms1334553imbalms
imbiber1333593imbiber
imbower14235663imbower
immane1038883immane_
impact122310453impa_ct
impacted15286353impacted
impacters15305483impacters
impactor14265003impactor
impacts13266503impacts
impaint11511223impaint
impaired1335143impaired
impairers1343713impairers
impairs1135823impairs
impaling1338253impaling
impaneled1443563impaneled
impanels1245233impanels
impark14287073impa_rk
imparked17264863imparked
imparks15276663imparks
impart102715143impa_rt
imparted13248063imparted
imparters13276573imparters
imparts11298533imparts
impasse11246463impasse
impasses12257523impasses
impaste11258003impaste
impasted13297553impasted
impastes12238193impastes
impasto11275193impasto
impavid1544553impavid
impawn1333263impa_wn
impawned1643443impawned
impawns1433323impawns
impeacher1843093impeacher
impearled1442863impearled
imped105117983imp__ed
impede11469623impede_
impeded13418183impeded
impeders13346593impeders
impedes124310093impedes
impel95711773imp__el
impelled1336073impelled
impellers1345103impellers
impellor1242743impellor
impels10389523impel_s
imphee13310353imp_hee
imphees1436693imphees
impinger13315423impinger
implant11311333implant
implanter1385363implanter
implead12315823imp_lead
impleader1444113impleader
implied1238623implied
implies11312123implies
implore11176703imp_lore
implorer12125103implorer
imply124911843imp_l_y
impone103011863impone_
imponed12279453imponed
impones112712253impones
importer12308913importer
impose103113053impose_
imposed123110293imposed
imposers12278463imposers
imposes113213683imposes
imposter12288163imposter
impowers15296823impowers
improper1444533improper
improver1545243improver
impugner13444233impugner
impulse1135113impulse
impulsed1334003impulsed
impulses1235223impulses
impure1038383impure_
impute1038043impute_
imputed1236533imputed
imputers1235823imputers
imputes1138083imputes
inaner62213543i_naner
inhale9411513inhale_
inhaled1169333inhaled
inhalers1166643inhalers
inhales10511863inhales
inhauler1163943inhauler
inlayer1036933inlayer
insaner7310443insaner
invader11146453invader
irater65218353i_rater
jimper17389863jimp__er
limper104117853limp__er
limpsier1234433limpsier
loyaler1035083loyaler
macer912126943_m_acer
mailer84724183_mailer
maker114127813_m_aker
malar76424443_m_alar
male66052303_m_ale_
males75049793_m_ales
maple95521143_maple_
maples104819423_maples
mapper124516093_mapper
maser75029973_m_aser
mater74438863_m_ater
mauler84416713_mauler
mazer165722423_m_azer
meager94515203_meager
mealier93015903_mealier
meaner84617843_meaner
mewler113510233_mewler
mickler153310233mickler
middler112712273middler
miler75733063_m_iler
miller84625413_miller
mingler104213843mingler
misalter1038343misalter
misaver1249813misaver
moaner84415113_moaner
moiler84017263_moiler
muller83820353_muller
nimbler11358063nim_bler
nopales93812523nopales
oilpaper1242853oilpaper
pacer96131613__pacer
pager84728203__pager
pale66055013__pale_
palea75028663__palea
paled85538723__paled
pales75753803__pales
palet74650803__palet
palier85023563__palier
palmer105816543__palmer
palter84423263__palter
paper95128663__paper
parer75839903__parer
pater74740723__pater
paver104225833__paver
pawer104422973__pawer
payer105125723__payer
pedaler103410693pedaler
pimple123512963pimp_le_
pimpled14289193pimp_led
pimples133012423pimp_les
pimplier1445413pimplier
poler74431793__poler
puler74826623__puler
rampager1344453rampager
realer63528593_realer
regaler83814623regaler
repaper11310023repaper
repealer103210703repealer
rimple103814583rimp_le_
rimpled123311423rimp_led
rimples113114223rimp_les
rippler113210103rippler
sampler113212013samp_ler
scaler84321603_scaler
sealer63928963_sealer
sepaled10510593sepaled
shoaler102610083shoaler
signaler945453signaler
simper103616293simp__er
simperer1237173simperer
simple104315173simp_le_
simples113014943simp_les
simplex18256393simp_lex
smaller93410333smaller
smearer94110403smearer
smeller94212783smeller
smiler83916683sm_iler
spacer104917793_spacer
spader94317133_spader
spale74929213_spale_
spales84728103_spales
spaller92713473_spaller
sparer84524963_sparer
staler64025823_staler
stapler93913633stapler
stealer72913973stealer
suppler1148433suppler
taler56034863__taler
thaler94613103_thaler
timbale11248803timbale_
timbales12227843timbales
tippler11348343tippler
vealer94016543_vealer
waler84229263__waler
whaler124611973_whaler
wimpier14248053wimp_ier
wimple133611363wimp_le_
wimpled15338823wimp_led
wimples143311173wimp_les

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 Filter1786911340270.406440125.6
2DLD Change Limit1340272606.36021073.4
3Display Results2602600.0932795.7
 (SQL Overall)1786912606.85926052.0
 
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.