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

446 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
defiler11391188(None) 
defier105118651defi_er
defile105216661defile_
defiled124013101defiled
defilers12439471defilers
defiles114016841defiles
definer114413771definer
ceiler84013962ce_iler
dealer74122142de_aler
decider114213182decider
decile94619212decile_
deciles104417722deciles
defacer132810362defacer
defamer132710322defamer
defer94619752def__er
deffer134411302def_fer
defied115016382defi_ed
defiers113913992defi_ers
defies104624052defi_es
define104718142define_
defined123813822defined
definers124211192definers
defines114118682defines
deflea1037442def_lea
defter104215922def_ter
defuser115110502defuser
deicer94114412de_icer
deifier113013122deifier
deliver113312242deliver
denier74420692deni_er
derider93214972derider
deriver114213912deriver
desilver12286502desilver
desirer8310782desirer
detailer9268672detailer
deviled124112182deviled
deviser114212392deviser
dewier104013462dewi_er
eviler94811892_eviler
exiler134712182_exiler
filer85433002__filer
refile95122372refile_
refiled114318652refiled
refiles104122422refiles
refilter1137152refilter
refiner105316912refiner
reviler104314972reviler
veiler93814352ve_iler
aedile73716653aedile_
aediles83413903aediles
aerier64823153aeri_er
affixer2033913affixer
baffler15418113baffler
bailer85425253_bailer
beefier12329093beefi_er
beetler938043beetler
befinger1434643befinger
beflea1147123bef_lea
befouler1343923befouler
beguiler1154063beguiler
belier84423563beli_er
beveler124010693beveler
bewailer1334863bewailer
bewilder1434133bewilder
bifilar1244043bifilar
boiler84319273_boiler
broiler92911753broiler
caviler1249063caviler
ceiled94114953ce_iled
ceilers93912533ce_ilers
coiler84421593_coiler
dabbler124012153dabbler
daffier1457833daffier
dafter104813343daf_ter
daiker115113033d_aiker
dallier84215373dallier
dandler94414273dandler
dangler96912813dangler
dawdler12356793dawdler
dazzler1634713dazzler
deader84220473de_ader
deadlier1036863deadlier
deafer104114813de_afer
deair65817193deai__r
deaired9411533deaired
dealers84118613de_alers
dearer74822803de_arer
debaser103510413debaser
debater104114693debater
debited113311623debited
deboner103110483deboner
decayer13339353decayer
deceiver1436233deceiver
deciare10710663deciare
decibel1235993decibel
decide104116873decide_
decided124312423decided
deciders123510753deciders
decides114217653decides
deciliter1247033deciliter
decipher1644423decipher
decker135215993de_cker
deckle1312012453deckle_
deckles143312803deckles
decliner113710843decliner
decoder113712293decoder
decolor1087033decolor
decoyer13348683decoyer
decreer10269123decreer
decrier102713553decrier
deedier93011593deedier
deeper93613503de_eper
deer56739023de___er
deface123113863deface_
defaced142910973defaced
defacers14237993defacers
defaces133213403defaces
defame123212433defame_
defamed14309833defamed
defamers14258523defamers
defames132812253defames
defaulter1343133defaulter
defeater122611663defeater
defender1337293defender
deferrer12135593deferrer
defers105116943def__ers
defi86321493defi___
defiant11311923defiant
deficit1339673deficit
defilade13124433defilade
defiladed15143473defiladed
defilades14134073defilades
defiling132812463defiling
defis96717503defi__s
deflater123211603deflater
defleas1147223def_leas
deflect13399973def_lect
deflower15126073deflower
defoamer14276213defoamer
defogger1443533defogger
deforcer14246903deforcer
deformer14247943deformer
defrayer1534933defrayer
deftly1336533deftl_y
defuel10348933def_uel
defueled1374513defueled
defuels11296983defuels
defuse105712723defuse_
defused125211093defused
defusers12487363defusers
defuses114814593defuses
defuze19487843defuze_
defuzed21447043defuzed
defuzes20398303defuzes
deice84320033de_ice_
deiced104214483de_iced
deicers103612733de_icers
deices94119373de_ices
deified123112413deified
deifiers12348993deifiers
deifies113317453deifies
deil56231623de_il__
deils65722863de_il_s
delayer113010533delayer
dele56843083de__le_
deled75326543de__led
deles65139253de__les
delime9314043delime_
delimed11310723delimed
delimes10314193delimes
delivers123310753delivers
delivery15286553delivery
dellies83622213dellies
deluder9168333deluder
delver104913493de_lver
demies94825803demi_es
demirep1236213demirep
demise94618323demise_
demised113613683demised
demises103719563demises
demister11310223demister
demurer1037873demurer
denied84318633deni_ed
deniers84515183deni_ers
denies74729643deni_es
denimed1159233denimed
denizen1737663denizen
denser74115193de_nser
dentiled1039743dentiled
denuder9167603denuder
depicter1356853depicter
deposer104011843deposer
depriver1446293depriver
derailed102410403derailed
deride84420033deride_
derided102914253derided
deriders102411853deriders
derides93420853derides
deringer1038143deringer
derive103817043derive_
derived123912763derived
derivers123811363derivers
derives114017813derives
dernier83011943dernier
desalter938363desalter
designer1036543designer
desilvers13306083desilvers
desire7415303desire_
desired9311983desired
desirers939263desirers
desires81316133desires
despiser1136343despiser
despoiler1243963despoiler
detailed10319873detailed
detailers10257253detailers
detainer92910793detainer
deter65028043de__ter
deticker1545283deticker
develed123611933develed
device124512163device_
devices133212583devices
devil94714733devil__
devilled1336743devilled
devilry1433973devilry
devils104412813devil_s
deviltry1542983deviltry
devise104215753devise_
devised123712563devised
devisee113812713devisee
devisers12339863devisers
devises114116763devises
devisor11357043devisor
dewater112912423dewater
dewily1338343dewil_y
dexie134716893dexi_e_
dexies145018343dexi_es
dexter143810893de_xter
dialer74315433d_ialer
dialler848813dialler
dibbler124510283dibbler
dicer85426423d__icer
dicier94416233dici_er
diddler103511513diddler
differ133910843dif_fer
diker105524553d__iker
dimer85625603d__imer
diner65632903d__iner
direr64927073d__irer
diver94827803d__iver
divider12278953divider
diviner11369883diviner
docile94213123docile_
doffer133911353dof_fer
doiled84817293d_oiled
doodler93310153doodler
dopier93515923dopi_er
dotier73917033doti_er
doubler103110083doubler
dozier163611633dozi_er
drainer83012843drainer
drawler11338593drawler
drier64423963d_ri_er
drifter11348703drifter
driller84311883driller
driver104714493d_river
droller84110283droller
dueler74213683d_ueler
dueller8329833dueller
duffer134711663duf_fer
duffle13368533duffle_
duffles14308923duffles
duiker114110593d_uiker
duller74017703d_uller
dweller11297273dweller
edgier8469733edgi_er
edifier11309263edifier
edile64819493_edile_
ediles74016983_ediles
eelier64216463eeli_er
eerier64320023eeri_er
eider64624743_e_ider
epimer10109153_epimer
eviller1056673_eviller
exile126117653_exile_
exiled144712463_exiled
exilers14419733_exilers
exiles134816403_exiles
feebler1235823feebler
feeler93215173fe_eler
feller94419553fe_ller
fiber104921133__fiber
fifer115519973__fifer
filar84819293__filar
file75446643__file_
filed95331903__filed
filers94623723__filers
files85441273__files
filet85540163__filet
filler94623623__filler
filmer114112403__filmer
filter94517633__filter
finer85431563__finer
firer811229253__firer
fiver116024943__fiver
fixer154717833__fixer
flier86023403__flier
frailer10319943frailer
gentler8378953gentler
hailer94720343_hailer
healer94221803he_aler
heckler16278573heckler
heeler93917313he_eler
hefter124313923hef_ter
heftier1337203heftier
heifer1238203he_ifer
heiled104415613he_iled
heller93322513he_ller
iffier1236763iffi_er
jailer134316683_jailer
jeweler1735053jeweler
kefir12457913kefi__r
kegeler1245493kegeler
kegler11398243ke_gler
leafier10329833leafi_er
lefter93613433lef_ter
leveler10399903leveler
levier94013873levi_er
mailer84724183_mailer
mealier93015903mealier
meddler11319953meddler
metier83517693meti_er
mewler113510233me_wler
miler75733063__miler
moiler84017263_moiler
muffler15398343muffler
nailer64119363_nailer
needler8388893needler
nestler73510453nestler
nettler7349503nettler
officer1534213officer
oiler54628283__oiler
pearler9310373pearler
pedaler103410693pedaler
peddler113210493peddler
pedler93614623pe_dler
peeler83517383pe_eler
penciler1237113penciler
penile82219603penile_
peopler1138083peopler
periled10316323periled
prefile123413183prefile_
prefiled143310573prefiled
prefiles133113443prefiles
profiler13287643profiler
raffler13339223raffler
railer64524933_railer
realer63528593re_aler
reciter94117263reciter
recoiler103210493recoiler
reefier102912553reefi_er
reeler63822573re_eler
refer84822143ref__er
refill94514053refil_l
refilled12278673refilled
refills103711423refills
refilm114311403refil_m
refilmed14235813refilmed
refilms12347503refilms
refilters1236103refilters
refine95225693refine_
refined114720003refined
refiners114713313refiners
refinery14447193refinery
refines105426343refines
refire95419473refire_
refired115116993refired
refires104820313refires
refixed183611153refixed
refixes174813173refixes
reflet94024233ref_let
reflew12389453ref_lew
reflex16359513ref_lex
reflies104418533reflies
refuser104912783refuser
refuter104312193refuter
regaler83814623regaler
reifier103414523reifier
reiver95318293re_iver
relier65826183reli_er
reoiled84316853reoiled
repiner94816903repiner
replier94214973replier
resider84615803resider
resile64627673resile_
resiled84621983resiled
resiles74026543resiles
resilver11337503resilver
retailer82911573retailer
retile65929673retile_
retiled84420513retiled
retiles74426993retiles
retirer74715013retirer
reveler104116343reveler
revile94921613revile_
reviled114417923reviled
revilers114011693revilers
reviles104421353reviles
reviser104114663reviser
reviver134411373reviver
riffler13328353riffler
rifler94014263rif_ler
ruffler13369723ruffler
sailer63526103_sailer
sealer63928963se_aler
sedile73517233sedile_
seiner64622483se_iner
seiser65318343se_iser
seizer154114573se_izer
seller63824603se_ller
senile63420213senile_
seniles72618023seniles
settler73410653settler
sexier13310683sexi_er
smiler83916683_smiler
spoiler93310683spoiler
stifler102911473stifler
tailer63823733_tailer
teller63519823te_ller
tiler56131023__tiler
toiler63918283_toiler
trailer73015393trailer
trifler103912153trifler
undefiled1446113undefiled
vealer94016543ve_aler
vealier102712173vealier
veiled103714543ve_iled
veilers103911823ve_ilers
veiner94514753ve_iner
veliger1137313veliger
verier94620963veri_er
vetiver1336103vetiver
viler86324163__viler
waffler16377783waffler
wailer93720323_wailer
weiner94214133we_iner
yeller94214513ye_ller

Search took 7 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 Filter1786911340270.406440125.6
2DLD Change Limit1340274466.11021935.7
3Display Results4464460.1732578.0
 (SQL Overall)1786914466.68926714.2
 
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.