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

183 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
devilling143670(None) 
deviling1311812851devi_ling
anvilling1336832anvilling
bedevilling1852552bedevilling
bevelling15227452bevelling
cavilling1536382cavilling
defiling132812462defi_ling
devaluing1434832devaluing
develing133212732dev_eling
deviating14311082deviating
devilkin1642952devilkin_
devilkins1742802devilkins
devising133111522devi_sing
devolving1733982devolving
drilling103311982d_rilling
levelling13206972levelling
perilling12410002perilling
rebilling12228832rebilling
refilling13299332refilling
revelling132412552revelling
reviling122917212revi_ling
anviling1239743anvi_ling
bedeviling1743483bedevi_ling
befalling15226503befalling
begalling13216493begalling
belling103825073be__lling
beveling143011033bev_eling
billing103823853__billing
brailling1247773brailling
caviling14310113cavi_ling
ceiling103416723ce_i_ling
celling103921263ce__lling
chilling143512183_chilling
deairing10311893deai_ring
dealing94323233de__aling
debiting122511203debi_ting
deciding132210833deci_ding
decillion1245833decillion
decillions1345433decillions
declining13129353declining
decupling1534973decupling
defilading1643643defilading
defining133711803defi_ning
defueling14255093defueling
defuelling1573543defuelling
dehiscing1643733dehiscing
deicing11312193de_i_cing
deifying1637633de_ifying
deigning1137753de_igning
deleing93313953de__leing
deliming12310373deli_ming
delisting112710503delisting
delving123711573de__lving
demising122012523demi_sing
demitting13239073demitting
depicting1537813depicting
depilating1439183depilating
derailing112011313derailing
deriding112512933deri_ding
deriving132510743deri_ving
desalting1138843desalting
designing1236623designing
desiring10312143desi_ring
desisting112810383desisting
detailing112510413detailing
deticking1736043deticking
deveining1436393deveining
developing1743673developing
devesting14249903devesting
devilfish1942323devilfish
devilish1546373devi_lish
devilled1336743devill_ed
devilment1547713devilment
devilries1345253devilries
devoicing16145223devoicing
devoting1338823dev_oting
devouring1435953devouring
dewooling1444323dewooling
dezincing2244183dezincing
dialing94318173d__ialing
dialling10310783d_ialling
dirling93316073d__irling
distilling1247793distilling
dividing1437183divi_ding
divining1338413divi_ning
divulging15103273divulging
divulsing14103933divulsing
dolling93817373d__olling
dowelling1466253dowelling
drillings11285823d_rillings
driveling1445763driveling
drivelling1543983drivelling
drolling103510763d_rolling
duelling103410733d_uelling
dulling93418273d__ulling
dwelling13368413d_welling
enisling949633_enisling
evicting1437483_evicting
evildoing1442223_evildoing
evincing1446183_evincing
eviting11511373_evi_ting
evolving1533433_evolving
evulsing1234733_evulsing
exiling15311083_exi_ling
felling113321133fe__lling
filling113520803__filling
frilling123011493_frilling
gavelling14286873gavelling
gelling93219763ge__lling
gilling93520383__gilling
grilling103811533_grilling
heiling113616363he_i_ling
helling114623223he__lling
hilling113821773__hilling
hovelling1636163hovelling
jelling153516613je__lling
jewelling2034833jewelling
killing123118723__killing
kvelling16146513_kvelling
leveling122910433lev_eling
medalling1346923medalling
melling102822623me__lling
metalling1249593metalling
milling103223683__milling
nilling83619563__nilling
pedalling1346663pedalling
pencilling1545473pencilling
periling11316863peri_ling
pilling103722563__pilling
prebilling1595413prebilling
prilling113413413_prilling
quilling182510003_quilling
ravelling13269243ravelling
rebelling122111163rebelling
recalling122211903recalling
redialing11311843redialing
redialling1246203redialling
redrilling1246073redrilling
refalling132010423refalling
refelling132211313refelling
refiling123116533refi_ling
refilming15256463refilming
regilding1236123regilding
reoiling93217213reoi_ling
repelling122312753repelling
repolling122110203repolling
rerolling102210373rerolling
reselling102213833reselling
resiling93520173resi_ling
retelling102112493retelling
retiling93319483reti_ling
retitling1039773retitling
revaluing1337303revaluing
revealing132611883revealing
reveling123117083rev_eling
reviewing1635513reviewing
revising122714403revi_sing
reviving152910503revi_ving
revolting1339633revolting
revolving1635843revolving
rilling84023623__rilling
rivalling1335963rivalling
schilling15286393schilling
selling83225833se__lling
shilling123315383_shilling
shrilling13307693shrilling
skilling132911333_skilling
spilling113113943_spilling
stilling93415323_stilling
swilling123511933_swilling
tefillin1143923tefillin_
telling83321083te__lling
thrilling13276693thrilling
tilling83522783__tilling
trilling92815963_trilling
twilling12268673_twilling
unwilling1337163unwilling
veiling113615293ve_i_ling
vialing113614163__vialing
vialling1237223__vialling
welling112920313we__lling
willing113821613__willing
yelling113516703ye__lling

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.440406115.9
2DLD Change Limit1486411836.97021325.8
3Display Results1831830.1061726.4
 (SQL Overall)1786911837.51623774.7
 
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.