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

154 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
medalling134692(None) 
medaling121912261meda_ling
metalling1249591metalling
pedalling1346661pedalling
befalling15226502befalling
begalling13216492begalling
malling103623662m__alling
medallic1345112medalli_c
medallion1244072medallion
medallions1343262medallions
medallist1246642medallist
meddling13257932med_dling
melling102822622me__lling
metaling111613722meta_ling
metalline1158732metalline
modelling1336882modelling
pedaling122412132peda_ling
recalling122211902recalling
redialling1246202redialling
refalling132010422refalling
appalling1444923appalling
balling104424763__balling
becalming1635283becalming
bedabbling1542293bedabbling
bedamning1534183bedamning
bedaubing1553193bedaubing
bedazzling2241933bedazzling
belling103825073be__lling
bevelling15227453bevelling
bewailing1536063bewailing
caballing1436883caballing
calling103826773__calling
canalling1239553canalling
celling103921263ce__lling
dallying13368493__dallying
darling93418363__darling
dealing94323233de_a_ling
derailing112011313derailing
desalting1138843desalting
detailing112510413detailing
devaluing1434833devaluing
devilling1436703devilling
dialling10310783_dialling
dolling93817373__dolling
dulling93418273__dulling
eagling91113603_e_agling
eanling81416673_e_anling
emailing113010043_emailing
embalming1644263embalming
empaling1338363empa_ling
enabling1138603_enabling
equalling1945243equalling
exalting1638033_exalting
eyeballing1642263eyeballing
falling113621583__falling
felling113321133fe__lling
fenagling1434553fenagling
galling93921963__galling
gelling93219763ge__lling
healing113922963he_a_ling
helling114623223he__lling
heralding1435773heralding
infalling1356243infalling
inwalling1385633inwalling
jelling153516613je__lling
jewelling2034833jewelling
lalling83519623__lalling
levelling13206973levelling
mailing102923343m__ailing
mallings113413093m__allings
malting103219083m__alting
manacling1446283manacling
marling103322763m__arling
mauling103315683m__auling
meaning103918703me_a_ning
medaillon1242653medaillon_
medaillons1352353medaillons
medalist11414213meda_list
medalled1246893medall_ed
medallists1344363medallists
mediating13311203mediating
melding113414273me__lding
melting103317753me__lting
menacing1339783mena_cing
metalising1348943metalising
metalizing22511363metalizing
metallic1247643metalli_c
metallics1346133metallics
metallike1555893metallike
metallist1159673metallist
metallize2067153metallize
metallizing2345753metallizing
mewling13329513me__wling
miauling1137343m_iauling
middling13249343mid_dling
milling103223683m__illing
misallying1644313misallying
miscalling1547863miscalling
misdialling1543303misdialling
modeling12311073mod_eling
muddling13268593mud_dling
mulling103819993m__ulling
palling104024483__palling
pealing104123203pe_a_ling
pearling11912013pe_arling
peddling13217973ped_dling
perilling12410003perilling
rebelling122111163rebelling
rebilling12228833rebilling
redacting13612303redacting
redating102620173reda_ting
reddling112911813red_dling
redialing11311843redialing
redrilling1246073redrilling
refelling132211313refelling
refilling13299333refilling
regaling10315363rega_ling
remailing122412473remailing
renailing102813333renailing
repelling122312753repelling
repolling122110203repolling
rerolling102210373rerolling
resailing103314253resailing
reselling102213833reselling
retailing103214733retailing
retallying1464703retallying
retelling102112493retelling
revaluing1337303revaluing
revelling132412553revelling
rivalling1335963rivalling
sandalling1245873sandalling
sealing83528563se_a_ling
sedating103014113seda_ting
selling83225833se__lling
smelling113712723sme__lling
spalling113213463_spalling
squalling1935173squalling
stalling95116703_stalling
teazling1856573te_azling
telling83321083te__lling
thralling13256833thralling
totalling1036523totalling
vealing114217423ve_a_ling
vialling1237223_vialling
walling113520973__walling
weakling16106763we_akling
weanling12118643we_anling
wedeling1338773wed_eling
welling112920313we__lling
yealing112716383ye_a_ling
yeanling12107063ye_anling
yearling1297883ye_arling
yelling113516703ye__lling
yodelling1435193yodelling

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 Filter1786911486410.406440125.6
2DLD Change Limit1486411546.81021826.9
3Display Results1541540.0632444.4
 (SQL Overall)1786911547.27924548.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.