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

326 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
defilers1243947(None) 
defiers113913991defi_ers
defiler113911881defiler_
defiles114016841defile_s
definers124211191definers
ceilers93912532ce_ilers
dealers84118612de_alers
deciders123510752deciders
deciles104417722decile_s
defacers14237992defacers
defamers14258522defamers
defers105116942def__ers
defier105118652defi_er_
defies104624052defi_e_s
defile105216662defile__
defiled124013102defile_d
definer114413772definer_
defines114118682define_s
defleas1147222def_leas
defusers12487362defusers
deicers103612732de_icers
deifiers12348992deifiers
delivers123310752delivers
deniers84515182deni_ers
deriders102411852deriders
derivers123811362derivers
desilvers13306082desilvers
desirers939262desirers
detailers10257252detailers
devisers12339862devisers
exilers14419732_exilers
filers94623722__filers
refiles104122422refile_s
refilters1236102refilters
refiners114713312refiners
revilers114011702revilers
veilers103911822ve_ilers
aediles83413903aedile_s
affixers2143293affixers
bafflers16356593bafflers
bailers94221353_bailers
beetlers1037403beetlers
befingers1544103befingers
befleas1236973bef_leas
befoulers1443123befoulers
beguilers1252883beguilers
beliers94617383beli_ers
bevelers13389463bevelers
bewailers1434233bewailers
bewilders1543813bewilders
boilers93417063_boilers
broilers103210093broilers
cavilers1348113cavilers
ceiler84013963ce_iler_
coilers93619903_coilers
dabblers13379363dabblers
daikers124010313d_aikers
dalliers93610623dalliers
dandlers103912053dandlers
danglers103610593danglers
dawdlers13375673dawdlers
dazzlers1733233dazzlers
deairs74013783deai__rs
dealer74122143de_aler_
debasers11377903debasers
debaters113511923debaters
deboners11268113deboners
debtless1135653debtless
decayers14307963decayers
deceivers1535723deceivers
deciares11510633deciares
decibels1344523decibels
decider114213183decider_
decides114217653decide_s
decile94619213decile__
deciliters1345173deciliters
deciphers1744393deciphers
deckers144413833de_ckers
deckles143312803deckle_s
decliners12358613decliners
decoders122810413decoders
decolors1187713decolors
decoyers14287713decoyers
decreers11277623decreers
decriers11299733decriers
deedless10318253deedless
deers64930523de___ers
defacer132810363defacer_
defaces133213403deface_s
defamer132710323defamer_
defames132812253defame_s
defaulters1442383defaulters
defeaters13289103defeaters
defenders1436363defenders
defer94619753def__er_
deferrers13115153deferrers
deffer134411303def_fer_
deficits1447283deficits
defied115016383defi_e_d
defilade13124433defilade
defilades14134073defilades
defiling132812463defiling
define104718143define__
defined123813823define_d
definiens1345303definiens
defis96717503defi___s
deflaters13298703deflaters
deflea1037443def_le_a
deflect13399973def_lect
deflects14336733def_lects
deflowers16145643deflowers
defoamers15285253defoamers
defoggers1543053defoggers
deforcers15265503deforcers
deformers15266533deformers
defrayers1644173defrayers
defter104215923def_ter_
deftness1236303deftness
defuels11296983def_uels
defuser115110503defuser_
defuses114814593defuse_s
defuzes20398303defuze_s
deicer94114413de_icer_
deices94119373de_ice_s
deifier113013123deifier_
deifies113317453deifie_s
deils65722863de_il__s
delayers12268663delayers
deles65139253de__le_s
delimes10314193delime_s
deliver113312243deliver_
delivery15286553delivery
dellies83622213dellie_s
deluders10156433deluders
delvers113411993de_lvers
demies94825803demi_e_s
demireps1343993demireps
demises103719563demise_s
demisters1249203demisters
denier74420693deni_er_
denies74729643deni_e_s
denizens1835573denizens
denuders10165873denuders
depicters1435823depicters
deposers11359243deposers
deprivers1545213deprivers
derider93214973derider_
derides93420853deride_s
deringers1137183deringers
deriver114213913deriver_
derives114017813derive_s
desalters1037673desalters
designers1136003designers
desilver12286503desilver_
desirer8310783desirer_
desires81316133desire_s
despisers1245153despisers
despoilers1343533despoilers
detailer9268673detailer_
detainers10269103detainers
deters74724683de__ters
detickers1634423detickers
devices133212583device_s
deviled124112183devile_d
devilry1433973devil_ry
devils104412813devil__s
deviltry1542983deviltry
devisees12358283devisees
deviser114212393deviser_
devises114116763devise_s
devisors12347253devisors
dewaters122910723dewaters
dewier104013463dewi_er_
dewiness1238453dewiness
dewless1137473de_wless
dexies145018343dexi_e_s
dialers83614303d_ialers
diallers957773diallers
dibblers13377583dibblers
dicers94720743d__icers
diddlers11359153diddlers
differs14339973dif_fers
dikers114418793d__ikers
dimers94321093d__imers
diners75525953d__iners
divers105024963d__ivers
dividers13257213dividers
diviners12308353diviners
doffers14359853dof_fers
doodlers10338843doodlers
doublers11288503doublers
drainers92811263drainers
drawlers12307313drawlers
driers74516733d_ri_ers
drifters12417913drifters
drillers9429723drillers
drivers114412793d_rivers
duelers83412053d_uelers
duellers9268223duellers
duffers143410093duf_fers
duffles14308923duffle_s
duikers12369383d_uikers
dwellers12356083dwellers
edifiers12336673edifiers
ediles74016983_edile_s
eiders74321363_e_iders
epimers11109493_epimers
eviler94811893_eviler_
exiler134712183_exiler_
exiles134816403_exile_s
feelers103814743fe_elers
fellers104117543fe_llers
fibers114717523__fibers
fifers125414923__fifers
filer85433003__filer_
files85441273__file_s
filets94718953__filets
fillers104320213__fillers
filmers124211293__filmers
filters103816553__filters
firers94922683__firers
fivers124420923__fivers
fixers165112983__fixers
fliers94417193__fliers
hailers104017263_hailers
healers104319463he_alers
hecklers17357123hecklers
heelers103815633he_elers
hefters134312003hef_ters
heifers1337933he_ifers
hellers103619833he_llers
jailers144114043_jailers
jewelers1834713jewelers
kefirs13396653kefi__rs
kegelers1355163kegelers
keglers12277773ke_glers
levelers11259323levelers
leviers103510343levi_ers
mailers94420333_mailers
meddlers12318203meddlers
metiers93312843meti_ers
mewlers12288983me_wlers
milers84625163__milers
moilers93615203_moilers
mufflers16316003mufflers
nailers73215893_nailers
needlers9287423needlers
nestlers8359233nestlers
nettlers8307513nettlers
officers1643803officers
oilers64721193__oilers
pearlers1039033pearlers
pedalers11239393pedalers
peddlers12298533peddlers
pedlers103013273pe_dlers
peelers93615593pe_elers
pencilers1345643pencilers
peoplers1237163peoplers
prefiles133113443prefile_s
profilers14236293profilers
rafflers14317373rafflers
railers74420673_railers
reciters102613113reciters
recoilers11318153recoilers
reelers73520273re_elers
refers93921083ref__ers
refile95122373refile__
refiled114318653refile_d
refills103711423refil_ls
refilms12347503refil_ms
refilter1137153refilter_
refiner105316913refiner_
refinery14447193refinery
refines105426343refine_s
refires104820313refire_s
refixes174813173refixe_s
reflets103513153ref_lets
reflies104418533reflie_s
refusers11499273refusers
refuters11449613refuters
regalers94311133regalers
reifiers11309843reifiers
reivers105117083re_ivers
reliers75519213reli_ers
repiners103913433repiners
repliers103710163repliers
residers93311883residers
resiles74026543resile_s
resilvers12306503resilvers
retailers9258773retailers
retiles74426993retile_s
retirers84311533retirers
revelers113414133revelers
reviler104314973reviler_
reviles104421363revile_s
revisers113511943revisers
revivers14389643revivers
rifflers14336453rifflers
riflers103512203rif_lers
rufflers14347193rufflers
sailers73822323_sailers
sealers74323553se_alers
seiners74219273se_iners
seisers73816393se_isers
seizers164112503se_izers
sellers73721323se_llers
seniles72618023senile_s
settlers8289023settlers
smilers94113853_smilers
spoilers10238633spoilers
stiflers11238833stiflers
tailers73720183_tailers
tellers73717613te_llers
tilers63523503__tilers
toilers74116263_toilers
trailers82912933trailers
triflers113110223triflers
vealers103214293ve_alers
veiler93814353ve_iler_
veiners104112523ve_iners
veligers1237023veligers
vetivers1435163vetivers
wafflers17306323wafflers
wailers103916813_wailers
weiners103913063we_iners
yellers103912953ye_llers

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.466383457.1
2DLD Change Limit1461623267.95318378.2
3Display Results3263260.1432279.7
 (SQL Overall)1786913268.56220870.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.