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

164 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
pedalling134666(None) 
medalling1346921medalling
pedaling122412131peda_ling
befalling15226502befalling
begalling13216492begalling
medaling121912262meda_ling
metalling1249592metalling
palling104024482p__alling
pealing104123202pe_a_ling
pearling11912012pe_arling
peddling13217972ped_dling
perilling12410002perilling
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
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
lalling83519633__lalling
levelling13206983levelling
malling103623663__malling
medallic1345113medalli_c
medallion1244073medallion
medallions1343263medallions
medallist1246643medallist
meddling13257933med_dling
melling102822633me__lling
metaling111613723meta_ling
metalline1158733metalline
modelling1336883modelling
paddling13218643pad_dling
paling93530133p__a_ling
palming123914013p__alming
palping124112873p__alping
panelling1239083panelling
parling103823763p__arling
peaching163613643pe_aching
peacing124117073pe_a_cing
peaking144317693pe_a_king
pebbling1535073pe_bbling
pedalier1137603peda_lier
pedalled1246933pedall_ed
pedaller1136093pedall_er
pedallers1244763pedallers
pedestalling1652563pedestalling
peeling102919873pe__eling
pelting102917273pe__lting
penalising1347623penalising
penalizing2249923penalizing
penancing1436343penancing
penciling1437413penciling
pencilling1545473pencilling
peopling1338353pe_opling
peptalking1943253peptalking
periling11316863pe_riling
pestling111010253pe_stling
petaline10314883peta_line
petallike1554633petallike
pettling1168213pe_ttling
piddling13208953pid_dling
pilling103722563p__illing
pinballing1544013pinballing
polling102920383p__olling
prebilling1595413prebilling
predating13514653preda_ting
predrilling1543673predrilling
preselling1338693preselling
pretelling1338133pretelling
prevailing1656723prevailing
prevaluing1644273prevaluing
prilling113413413p_rilling
psalming1375473p_salming
puddling13218033pud_dling
pulling103821073p__ulling
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
spalling113213463_spalling
speedballing1861293speedballing
spelling113315233spe__lling
spiralling1343963spiralling
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.423422437.4
2DLD Change Limit1486411647.43619989.4
3Display Results1641640.0802050.0
 (SQL Overall)1786911647.93922508.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.