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

360 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
emailing11301004(None) 
mailing102923341_mailing
remailing122412471remailing
ailing74331012__ailing
availing1267282availing
bailing103723522_bailing
bewailing1536062bewailing
brailing113514792brailing
derailing112011312derailing
detailing112510412detailing
eagling91113602e_agling
eanling81416672e_anling
empaling1338362empaling
enabling1138602enabling
ensiling9410722ensiling
entailing1039392entailing
exiling15311082e_xiling
failing113521332_failing
flailing12298922flailing
hailing113820692_hailing
jailing153415842_jailing
mailings113011922_mailings
maiming122912722_maiming
malling103623662_malling
marling103322762_marling
mauling103315682_mauling
moiling103417662_moiling
nailing83419962_nailing
quailing1838402quailing
railing83325642_railing
remaining122212792remaining
renailing102813332renailing
resailing103314252resailing
retailing103214732retailing
sailing83927372_sailing
smiling103915442sm_iling
snailing92912972snailing
tailing82923102_tailing
trailing92916092trailing
vailing113817942_vailing
wailing113620902_wailing
aiding84423613__aiding
aiming94320843__aiming
airing74927503__airing
airmailing1343633airmailing
amassing1138003amassing
amazing1938813ama_zing
ambling121411793am_bling
anviling1239743anviling
assailing1036023assailing
awaiting1238273awaiting
baiting103918883_baiting
baling94829693_ba_ling
balling104424763_balling
bawling133813863_bawling
befalling15226503befalling
begalling13216493begalling
beguiling1334853beguiling
bemiring13239603bem_iring
bemixing20226523bem_ixing
besmiling1436263besmiling
boiling103819673_boiling
braiding123112703braiding
brailling1247773brailling
braining113414683braining
braising113014563braising
brawling143210043brawling
broiling113112013broiling
cabling124017553_cabling
calling103826773_calling
carling103727063_carling
catling104819793_catling
caviling14310113caviling
ceiling103416723_ceiling
chaining142810783chaining
chairing143110773chairing
claiming13279303claiming
coaling103722823coa_ling
coiling103723453_coiling
compiling1637763compiling
craaling112711353craaling
cradling122411453cradling
crawling143110513crawling
darling93418363_darling
deairing10311893deairing
dealing94323233dea_ling
defiling132812463defiling
demanding14237923demanding
demarking1736773demarking
demasting1338453demasting
demising122012523dem_ising
detailings12243923detailings
detaining112510473detaining
deviling1311812853deviling
dialing94318173dia_ling
dialling10310783dialling
draining103312673draining
drawling13318673drawling
eanlings9128473e_anlings
earing75235483e_a_ring
earning83418213e_arning
earring83519013e_arring
easing74926463e_a_sing
easting84924303e_asting
eating75134403e_a_ting
editing9313133e_diting
elapsing1146713elapsing
elating83423083ela_ting
eliding93414343e_liding
eloining9310443eloining
emaciating1546813emaciating
email74715103email___
emailed10359213email_ed
emails84412343email__s
emanating1239003emanating
embalming1644263embalming
embanking1843813embanking
embarking1844193embarking
embarring1444513embarring
embattling1542193embattling
embaying1635263embaying
embowing1636243embowing
embroiling1544543embroiling
embruing1344523embruing
emceeing1343573emceeing
emending12298893emending
emerging1237893emerging
emitting112410353emitting
emoting10313563em_oting
empaneling1573403empaneling
emptying1634243emptying
enacting11311363enacting
enameling1246123enameling
enditing10311073enditing
engilding1244483engilding
engining1039293engining
engrailing1244853engrailing
enisling949633enisling
enticing11311803enticing
entitling1037103entitling
entoiling1038483entoiling
equaling1837793equaling
equalling1945243equalling
erasing8317963era_sing
evading1237283eva_ding
eviting11511373e_viting
exacting1838523exacting
exalting1638033exalting
examining1945143examining
exampling2143553exampling
exciding1935923exciding
excising1837213excising
exciting1838023exciting
exhaling1936293exhaling
exiting15311393e_xiting
expiring1836253expiring
fabling133413623_fabling
failings123811013_failings
fairing113614013_fairing
falling113621583_falling
fatling113815683_fatling
fenagling1434553fenagling
filing103823763__filing
flatling123410013flatling
foaling113515843foa_ling
foiling113317653_foiling
gabling113514543_gabling
gaining94015663_gaining
gaiting93716583_gaiting
galling93921963_galling
gambling14218963gambling
gaoling93314653_gaoling
glairing1047283glairing
gnarling10217603gnarling
goaling93515333goa_ling
graining102813183graining
grayling1338003grayling
guiling93214213_guiling
haling104229783_ha_ling
hauling113714433_hauling
healing113922963hea_ling
heiling113616363_heiling
imaging1138083ima_ging
imagining1345413imagining
imbibing1534043imbibing
immixing2043543immixing
impairing1445473impairing
impaling1338253impaling
kraaling13186663kraaling
ladling92813393_ladling
lairing83715343_lairing
lalling83519623_lalling
liaising937913liaising
macing114221553_ma_cing
mackling172710063_mackling
maculing13219583_maculing
madding123711993_madding
mailbag1243923_mailbag
mainline1039863_mainline
making134823853_ma_king
malign939853_ma_lign
maline84529083_ma_line
mallings113413093_mallings
malting103219083_malting
mangling122312623_mangling
manning103616383_manning
mantling112012613_mantling
mapping143413993_mapping
marbling13179883_marbling
marking144020133_marking
marlin84220903_marlin_
marline93320953_marline
marlings113713493_marlings
marlins93420473_marlins
marring103319553_marring
marting103325013_marting
mashing134422243_mashing
masking145116613_masking
massing104318023_massing
masting104325823_masting
mating94832913_ma_ting
matting103620143_matting
mawing124020803_ma_wing
maxing164817073_ma_xing
maying124421153_ma_ying
mazing184418973_ma_zing
meaning103918703mea_ning
medaling121912263medaling
medalling1346923medalling
meddling13257933meddling
melling102822623_melling
meriting11314683meriting
metaling111613723metaling
metalling1249593metalling
mewling13329513_mewling
miauling1137343miauling
miking134218463_m_iking
milding113615453_m_ilding
milking143712763_m_ilking
milling103223683_milling
milting103619123_m_ilting
miming114317263_m_iming
mining94225453_m_ining
miring93723803_m_iring
mixing164713943_m_ixing
muling93519883_m_uling
mulling103819993_mulling
oiling74925313__oiling
paiking143814813_paiking
paining103920243_paining
pairing103716733_pairing
paling93530133_pa_ling
palling104024483_palling
parling103823763_parling
pealing104123203pea_ling
pearling11912013pearling
pedaling122412133peda_ling
pedalling1346663pedalling
penciling1437413penciling
periling11316863periling
piling95025593__piling
plaining113911553plaining
plaiting113113513plaiting
praising113214563praising
prevailing1656723prevailing
raiding93617593_raiding
railings93412153_railings
raining83922693_raining
raising83220533_raising
rambling131810773rambling
reavailing1444873reavailing
rebaiting12311643rebaiting
reboiling12149823reboiling
recalling122211903recalling
recoiling121412413recoiling
redialing11311843redialing
refalling132010423refalling
refiling123116533refiling
regaining112411083regaining
regaling10315363rega_ling
remaking152613303rema_king
remanding132211143remanding
remanning12229033remanning
remapping1635023remapping
remarking1638893remarking
remating112322413rema_ting
remising112516453rem_ising
remixing182810333rem_ixing
reoiling93217213reoiling
repairing12310013repairing
reraising10313773reraising
resiling93520173resiling
retailings11265233retailings
retaining102114733retaining
retiling93319483retiling
reviling122917213reviling
riling74227973__riling
roiling83220453_roiling
sailings93513253_sailings
saining83621393_saining
sampling13510643sampling
sapling103217863_sapling
scaling103519373sca_ling
sealing83528563sea_ling
shauling1249393shauling
shawling1558223shawling
smacking173510763smacking
smarting113212453smarting
smashing143310243smashing
smelling113712723smelling
smiting103014443sm_iting
snarling92513183snarling
soiling83422323_soiling
spalling113213463spalling
sparling112714533sparling
speiling113612973speiling
spiling102919703_spiling
spoiling112911553spoiling
stabling112913653stabling
staining9413373staining
staling83925423sta_ling
stalling95116703stalling
stapling112813153stapling
starling93017123starling
tabling103216033_tabling
tailings93211673_tailings
teazling1856573teazling
tiling73426553__tiling
toenailing1143573toenailing
toiling83219023_toiling
traiking132511973traiking
training93015863training
trawling122710783trawling
umpiring1336093umpiring
unfailing1337453unfailing
unnailing1037023unnailing
unpiling1139753unpiling
uppiling1335853uppiling
vealing114217423vea_ling
veiling113615293_veiling
vialing113614163via_ling
vialling1237223vialling
waifing142910893_waifing
wairing113414313_wairing
waiting113618953_waiting
waiving14329633_waiving
waling104525303_wa_ling
walling113520973_walling
wambling16198443wambling
wauling112713113_wauling
wawling143810963_wawling
weakling16106763weakling
weanling12118643weanling
whaling143910773wha_ling
whiling143511743_whiling
wiling103024293__wiling
yawling14369183_yawling
yealing112716383yea_ling
yeanling12107063yeanling
yearling1297883yearling

Search took 9 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.1561145455.1
2DLD Change Limit1461623608.03018202.0
3Display Results3603600.1402571.4
 (SQL Overall)1786913608.32621461.8
 
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.