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

376 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
impales11331176(None) 
empales112411431empales
impalas11236951impalas
impale102811661impale_
impaled12288511impaled
impaler11298391impaler
impalers12226971impalers
ampules1189432ampules
dimples122813212dimp_les
empale102611262empale_
empaled12288952empaled
empaler11288352empaler
empalers12226742empalers
images91411462im_ages
imbalms1334552imbalms
impacts13266502impacts
impairs1135822impairs
impala10256932impal_a
impanel1137092impanel
impanels1245232impanels
imparks15276662imparks
imparts11298532imparts
impasse11246462impasse
impasses12257522impasses
impastes12238192impastes
impawns1433322impawns
impedes124310092impedes
impels10389522impel_s
imphees1436692imphees
impled113812512imp_led
implies11312122implies
impones112712252impones
imposes113213682imposes
impulse1135112impulse
impulses1235222impulses
imputes1138082imputes
inhales10511862inhales
males75049792_m_ales
maples104819422_maples
nopales93812522nopales
pales75753802__pales
pimples133012422pimp_les
rimples113114222rimp_les
simples113014942simp_les
spales84728102_spales
timbales12227842timbales
wimples143311172wimp_les
ales47067103___ales
amazes175613473am_azes
ambages1269623ambages
ambles105121863am_bles
amoles84122193am_oles
amperes11313983amperes
ample94720303amp_le_
ampler104313303amp_ler
amplest11312333amp_lest
ampoules1275853ampoules
ampule10710613ampule_
ampuls1098893ampul_s
appalls11337743appalls
appals104812943appal_s
apples104315763_apples
bales76250083__bales
bubales113513343bubales
compares143816433compares
compiles14311983compiles
copalms13367543copalms
copals105018943copal_s
crimples14308963crimp_les
cupules113210263cupules
dales66439743__dales
dapples1238993dapples
dimple113512793dimp_le_
dimpled132810303dimp_led
dipoles101013753dipoles
embalms1335333embalms
empanel1145963empanel
empanels1244823empanels
emphases1568353emphases
empires1139853empires
emplaces1438413emplaces
emplanes1239503emplanes
empties11712243empties
exhales1737143exhales
females12310663females
fimbles143510663fim_bles
finales104016013finales
fipples14298653fipples
gales65442483__gales
gimbaled14104173gimbaled
gimbals12257823gimbal_s
gimmals12225823gimmal_s
hales85449843__hales
hapaxes1936593hapaxes
hirples12149643hirp_les
hopples142810713hopples
icicles1135943icicles
idealess935653idealess
ideals75012503ideal_s
ideates8313733ideates
idles66720123i__dles
image81411293im_age_
imaged1097763im_aged
imager9108123im_ager
imagers10107763im_agers
imagoes10126403imagoes
imagos9117553im_agos
imamates1237663imamates
imams91511113im_a_ms
imaret81121233im_aret
imarets9138643im_arets
imaums10106303im_aums
imbalm1246323imbal_m
imbalmed1543293imbalmed
imbalmer1443193imbalmer
imbalmers1543103imbalmers
imbarks15326613imbarks
imbibes1334693imbibes
imblazes2144723imblazes
imbrues1135503imbrues
imbues1037983im_bues
imides94515343im_ides
imines84918353im_ines
imitates10310503imitates
immane1038883immane_
immies102412443im_mies
immixes1835073immixes
immunes1136083immunes
immures1136713immures
impact122310453impa_ct
impacted15286353impacted
impacter14296573impacter
impacters15305483impacters
impaint11511223impaint
impaints1236243impaints
impair1036003impa_ir
impaired1335143impaired
impairer1244863impairer
impairers1343713impairers
impaling1338253impaling
impaneled1443563impaneled
impark14287073impa_rk
imparked17264863imparked
impart102715143impa_rt
imparted13248063imparted
imparter12357543imparter
imparters13276573imparters
impaste11258003impaste
impasted13297553impasted
impasto11275193impasto
impastos12244833impastos
impatiens1345733impatiens
impavid1544553impavid
impawn1333263impa_wn
impawned1643443impawned
impeaches1843873impeaches
impearled1442863impearled
impearls1253883impearls
imped105117983imp__ed
impede11469623impede_
impeded13418183impeded
impeder12438533impeder
impeders13346593impeders
impel95711773imp__el
impelled1336073impelled
impeller1236083impeller
impellers1345103impellers
impends12376803impends
impetus1144893impetus
imphee13310353imp_hee
impinges13297423impinges
impings12348553impings
impious1137063impious
impis96213853imp__is
implant11311333implant
implants1237883implants
implead12315823imp_lead
impleads13294593imp_leads
implied1238623implied
implodes13106393implodes
implores12127043implores
imply124911843imp_l_y
impone103011863impone_
imponed12279453imponed
imports11309623imports
impose103113053impose_
imposed123110293imposed
imposer113310103imposer
imposers12278463imposers
imposts11269003imposts
impower14247123impower
impowers15296823impowers
impresa1134753imp_resa
imprese1138143imp_rese
impreses1238093impreses
impress1137773impress
imprest11310203imp_rest
improves1536123improves
improvs1435003improvs
imps86221123imp___s
impugns1243333impugns
impulsed1334003impulsed
impure1038383impure_
impurer1136483impurer
impurest1245913impurest
impute1038043impute_
imputed1236533imputed
imputer1136533imputer
imputers1235823imputers
inanes62519803i_nanes
incages103013883incages
incases93615973incases
indoles83716363indoles
infalls1038943infalls
infares10313023infares
ingates82716913ingates
ingles74420873i_ngles
inhale9411513inhale_
inhaled1169333inhaled
inhaler1068053inhaler
inhalers1166643inhalers
inkles103515653i_nkles
inlaces92512903inlaces
inmates92715783inmates
innages82911303innages
insoles73516243insoles
intakes11310943intakes
invades11118293invades
inwalls1037283inwalls
iodates8312903iodates
irades74517393i_rades
isles54220563i__sles
istles62814983i_stles
ixtles13217063i_xtles
jacales16310323jacales
kales95730983__kales
lampases1267293lampases
limeades11116643limeades
limpas105513083limpa__s
lipases9209483lipases
locales93715093locales
mabes96331533_m_abes
maces97139963_m_aces
macles107023223_macles
maes66948403_m_a_es
mages85036023_m_ages
mailes84329113_mailes
makes115336853_m_akes
male66052303_m_ale_
malls76233433_m_alls
malms95021553_m_alms
malts76331753_m_alts
manes76648963_m_anes
maple95521143_maple_
mares76457633_m_ares
mates75251363_m_ates
maxes145629533_m_axes
mazes165632173_m_azes
mealies92821933_mealies
meals75933373_meal_s
measles92412753_measles
merles85322763_merles
mickles153415003mickles
middles113415303middles
miggles113512033miggles
milages103114403milages
miles74645073_m_iles
milles84526563_milles
mingles103719003mingles
miracles1238333miracles
mirages102213533mirages
mispages13311183mispages
mizzles17329493mizzles
moles74747923_m_oles
morales93619403morales
mules75034293_m_ules
myases113711553_myases
napalms1144033napalms
nipples11319663nipples
nopals84914023nopal_s
omphalos1543693omphalos
opals75718353_opal_s
paces96741113__paces
padles95221123__padles
pages85235073__pages
pale66055013__pale_
palea75028663__palea
paled85538723__paled
paler75436933__paler
palest83926223__palest
palet74650803__palet
palets85122313__palets
palls74332563__palls
palms94921753__palms
palps94719563__palps
pals66951353__pal_s
panes76148693__panes
papules112411573papules
pares77164483__pares
parles86334403__parles
pases75346503__pases
pates76047893__pates
paves104833923__paves
paxes144928423__paxes
peles75738083__peles
piles74742613__piles
pimple123512963pimp_le_
pimpled14289193pimp_led
pinwales1367963pinwales
pipages1289423pipages
pipals104213643pipal_s
poles75351003__poles
popples103011873popples
pules74538813__pules
pupates113311433pupates
rales54947493__rales
rampages1336673rampages
rampoles1238893rampoles
reales64934123_reales
regales83520793regales
repaves123513653repaves
resales74724903resales
rimple103814583rimp_le_
rimpled123311423rimp_led
ripples113513293ripples
rumples113313133rump_les
sales56055593__sales
samples112815453samp_les
scales84529313_scales
sepaled10510593sepaled
sepals85217373sepal_s
shales94731253_shales
similes92915233sim_iles
simple104315173simp_le_
simpler112910863simp_ler
simplest122310223simp_lest
simplex18256393simp_lex
smalls84514123sm_alls
smalts85214893sm_alts
smazes174311663sm_azes
smiles84522293sm_iles
spaces104722633_spaces
spades94222583_spades
spaes76029973_spa_es
spale74929213_spale_
spalls84217343_spalls
spares84834553_spares
spates85028173_spates
spiles84227913_spiles
stales65538293_stales
staples93617213staples
supples11511283supples
swales93920763_swales
tales55451373__tales
tamales93216153tamales
tampalas1245473tampalas
tapalos938813tapalos
temples112610893temp_les
tepals85415043tepal_s
timbale11248803timbale_
timbals11239533timbal_s
tipples112811253tipples
topazes1857313topazes
topples113111653topples
umbles103817493um_bles
umpires1137813umpires
unbales92914863unbales
unpiles92112783unpiles
upases84112903_upases
uppiles11208263uppiles
vales85434263__vales
wales86142833__wales
whales124716943_whales
wimbles143010853wim_bles
wimple133611363wimp_le_
wimpled15338823wimp_led

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 Filter1786911340270.470380193.6
2DLD Change Limit1340273767.18618651.1
3Display Results3763760.1432629.4
 (SQL Overall)1786913767.79922912.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.