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

416 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
defiling13281246(None) 
defining133711801defining
deviling1311812851deviling
refiling123116531refiling
ceiling103416722ce_iling
deairing10311892deairing
dealing94323232de_aling
debiting122511202debiting
deciding132210832deciding
defacing15238682defacing
defaming15238462defaming
defilading1643642defilading
defueling14255092defueling
defusing13227932defusing
defuzing22195252defuzing
defying15328822def_ying
deicing11312192de_icing
deifying1637632deifying
deliming12310372deliming
demising122012522demising
derailing112011312derailing
deriding112512932deriding
deriving132510742deriving
desiring10312142desiring
detailing112510412detailing
develing133212732develing
devilling1436702devilling
devising133111522devising
exiling15311082_exiling
filing103823762__filing
heiling113616362he_iling
periling11316862periling
prefiling1549532prefiling
refilling13299332refilling
refilming15256462refilming
refining122416862refining
refiring123513922refiring
refixing19329792refixing
reoiling93217212reoiling
resiling93520172resiling
retiling93319482retiling
reviling122917212reviling
veiling113615292ve_iling
affixing2264333affixing
ailing74331013__ailing
anviling1239743anviling
availing1267283availing
baffling1756053baffling
bailing103723523_bailing
bedeviling1743483bedeviling
beetling1139283beetling
befalling15226503befalling
befitting15236623befitting
befooling1535053befooling
befouling1534983befouling
beguiling1334853beguiling
belling103825073be_lling
bemiring13239603bemiring
bemixing20226523bemixing
beriming13310463beriming
besmiling1436263besmiling
betiding1239913betiding
beveling143011033beveling
bewailing1536063bewailing
boiling103819673_boiling
brailing113514793brailing
broiling113112013broiling
caviling14310113caviling
ceilings11397993ce_ilings
celling103921263ce_lling
coffling1736483coffling
coiling103723453_coiling
dabbling14227973dabbling
daddling12258233daddling
daffing15369733daf_fing
daggling12237063daggling
dandling112511733dandling
dangling112611233dangling
dappling1436843dappling
darkling1437483darkling
darling93418363d_arling
dartling1039563dartling
dawdling14236373dawdling
dazzling1834363dazzling
deadline10139053deadline
deafening1476273deafening
dealings103510703de_alings
deaning94020473de_aning
deashing134210953deashing
deaving123814753de_aving
debasing12238063debasing
debating123213733debating
debility1448633debility
deboning12109153deboning
debriding1446483debriding
debuting12268633debuting
decaying15239453decaying
deceiving1635733deceiving
decking153915593de_cking
decline103716613de_cline
declining13129353declining
decoding132410053decoding
decoying15208763decoying
decrying15237413decrying
decupling1534973decupling
deducing1336423deducing
deeding103315123de_eding
deeming113913123de_eming
defang1137753def__ang
defanging1535333defanging
defatting1436103defatting
defaulting1543393defaulting
defeating142311973defeating
defecting162510223defecting
defencing16226693defencing
defending15298353defending
defensing14217003defensing
deferring1436143deferring
defiant11311923defi_ant
deficient1547023deficient
deficit1339673defici_t
deficits1447273deficits
defilade13124433defilade
defile105216663defil__e
defiled124013103defil_ed
defiler113911883defil_er
defilers12439473defilers
defiles114016843defil_es
define104718143def__ine
definiens1345303definiens
definite1239323definite
deflating142610713deflating
defleaing1444743defleaing
defoaming1645653defoaming
defogging1653863defogging
defoliant1345203defoliant
deforcing1636063deforcing
deforming1636703deforming
defraying1735853defraying
defuelling1573543defuelling
defunding15216123defunding
dehiscing1643733dehiscing
deigning1137753deigning
dekeing13358353de_keing
deking125614553de__king
delating103119603delating
delaying133210973delaying
deleing93313953de_leing
deleting103314423deleting
delisting112710503delisting
deluding1137683deluding
deluging1137123deluging
delving123711573de_lving
demilune1144423demilune
demitting13239073demitting
demoing11311753de_moing
demoting12311423demoting
denning93515173de_nning
denoting10311753denoting
denting94422183de_nting
denuding1137113denuding
denying123711293de_nying
depicting1537813depicting
depilating1439183depilating
deponing121211213deponing
deposing12129773deposing
depriving1636403depriving
deputing12238793deputing
derating103222283derating
desalting1138843desalting
desexing1736293desexing
designing1236623designing
desisting112810383desisting
despising13167503despising
despiting13179323despiting
despoiling1445113despoiling
destining11311433destining
detailings12243923detailings
detaining112510473detaining
deticking1736043deticking
detoxing1736313detoxing
deucing1139393de_ucing
devaluing1434833devaluing
deveining1436393deveining
deviating14311083deviating
devilish1546373devilish
devilkin1642953devilkin_
devilkins1742803devilkins
devoicing16145223devoicing
devolving1733983devolving
devoting1338823devoting
dewaxing20215293dewaxing
dewing114115703de__wing
dewooling1444323dewooling
dezincing2244183dezincing
dialing94318173d_ialing
dialling10310783dialling
dibbling14247333dibbling
dicing105718763d__icing
diddling12228743diddling
dieing84018653d__ieing
dieseling1146143dieseling
diking124320243d__iking
dimpling14199023dimpling
dindling112411163dindling
dining84525133d__ining
dirling93316073d_irling
dividing1437183dividing
diving113717953d__iving
divining1338413divining
doffing15357793dof_fing
doling84923133d__oling
dolling93817373d_olling
doodling11218403doodling
doubling1238153doubling
doweling13279763doweling
draining103312673draining
drawling13318673drawling
drifting13338733drifting
drilling103311983drilling
driving123910713d_riving
drolling103510763drolling
drooling102610423drooling
duckling16247703duckling
dueling93614543d_ueling
duelling103410733duelling
dulling93418273d_ulling
dumpling14217893dumpling
dwelling13368413dwelling
dwining12269293d_wining
eagling91113603_eagling
eanling81416673_eanling
edifying1636083edifying
editing9313133_editing
eliding93414343_eliding
emailing113010043emailing
enisling949633_enisling
ensiling9410723ensiling
eviting11511373_eviting
exiting15311393_exiting
failing113521333_failing
feeling113617073fe_eling
felling113321133fe_lling
feruling1258873feruling
fettling1266773fettling
fifing134212343__fifing
filings115213073__filings
filling113520803__filling
filming133210353__filming
fining104223213__fining
firing104021723__firing
fixing174813783__fixing
flailing12298923flailing
fling97023513__f_ling
foiling113317653_foiling
gelling93219763ge_lling
gentling1048453gentling
guiling93214213_guiling
hailing113820693_hailing
healing113922963he_aling
heckling18257163heckling
heeling113618513he_eling
hefting144510913hef_ting
heiring113312903he_iring
helling114623223he_lling
infixing1936103infixing
jailing153415843_jailing
jelling153516613je_lling
jeweling1935483jeweling
keckling14245523keckling
keeling123515123ke_eling
kegling13309363ke_gling
leftwing1532973leftwing
leniting9312353leniting
leveling122910433leveling
mailing102923343_mailing
medaling121912263medaling
meddling13257933meddling
melling102822623me_lling
meriting11314683meriting
metaling111613723metaling
mewling13329513me_wling
misfiling1537223misfiling
moiling103417663_moiling
muffling1765503muffling
nailing83419963_nailing
needling10248753needling
nestling958893nestling
nettling957213nettling
oiling74925313__oiling
pealing104123203pe_aling
pearling11912013pearling
pebbling1535073pebbling
pedaling122412133pedaling
peddling13217973peddling
peeling102919873pe_eling
peining104619153pe_ining
peising103416763pe_ising
penciling1437413penciling
peopling1338353peopling
perilling12410003perilling
pestling111010253pestling
pettling1168213pettling
piffling1745133piffling
piling95025593__piling
prefiring1559073prefiring
prefixing2246783prefixing
profiling1548233profiling
quailing1838403quailing
raffling1567063raffling
railing83325643_railing
rebilling12228833rebilling
reboiling12149823reboiling
reciting113118073reciting
recoiling121412413recoiling
reddling112911813reddling
redefining1545423redefining
redialing11311843redialing
reedling102414273reedling
reeling83126863re_eling
refacing142512813refacing
refalling132010423refalling
refeeling13229313refeeling
refelling132211313refelling
reffing143712173ref_fing
refinding14259943refinding
refitting132811123refitting
reflying15268173reflying
refolding1437453refolding
refrying15278903refrying
refueling13227973refueling
refuging13218423refuging
refusing122310873refusing
refuting121911903refuting
regaling10315363regaling
regilding1236123regilding
regiving13269713regiving
rehiring122911883rehiring
reifying1539383reifying
reining84425323re_ining
reiving113316843re_iving
relining93218743relining
reliving122713343reliving
remailing122412473remailing
remising112516453remising
remixing182810333remixing
renailing102813333renailing
repining114116593repining
rerising93017783rerising
resailing103314253resailing
residing103015473residing
resilin72913973resilin_
resilins83013373resilins
resining92919553resining
resiting93521123resiting
resizing182714163resizing
resoling92916303resoling
retailing103214733retailing
retieing92913713retieing
retiming113014193retiming
retiring92717413retiring
retitling1039773retitling
reveling123117083reveling
revising122714403revising
reviving152910503reviving
rewiring122911223rewiring
riffling1556113riffling
rifling112815013rif_ling
riling74227973__riling
roiling83220453_roiling
ruffling1546093ruffling
sailing83927373_sailing
sealing83528563se_aling
seedling102610953seedling
seeling83522003se_eling
seining84020773se_ining
seising84018863se_ising
seizing174114833se_izing
selling83225833se_lling
settling978943settling
smiling103915443_smiling
snailing92912973snailing
soiling83422323_soiling
speiling113612973speiling
spiling102919703_spiling
spoiling112911553spoiling
stifling122110913stifling
tailing82923103_tailing
teazling1856573teazling
tefillin1143923tefillin_
telling83321083te_lling
tiling73426553__tiling
toiling83219023_toiling
trailing92916093trailing
trifling122411503trifling
unfailing1337453unfailing
unfixing1935683unfixing
unpiling1139753unpiling
upfling1337093upf_ling
uppiling1335853uppiling
vailing113817943_vailing
vealing114217423ve_aling
veilings12357313ve_ilings
veining114713893ve_ining
waffling1845423waffling
wailing113620903_wailing
weakling16106763weakling
weanling12118643weanling
wedeling1338773wedeling
welling112920313we_lling
whiling143511743_whiling
wiling103024293__wiling
yealing112716383ye_aling
yeanling12107063yeanling
yearling1297883yearling
yelling113516703ye_lling

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.423422437.4
2DLD Change Limit1461624167.64019131.2
3Display Results4164160.1732404.6
 (SQL Overall)1786914168.23621696.3
 
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.