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

142 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
debacles133572(None) 
debacle1237441debacle_
cenacles1238022cenacles
debases103814132deba_ses
debates103718532deba_tes
debauches17124062debauches
defaces133213402defac_es
detaches1439652detaches
abbacies1445483abbacies
baches135426943__baches
bales76250083__ba_les
beaches144120653be_aches
beadles103414733be_adles
beagles103212123be_agles
bubales113513343buba_les
cenacle1139123cenacle_
coracles121811163coracles
cubicles1435883cubicles
dabbles124514773dab_bles
daces85030683d__ac_es
dales66439743d__a_les
dalles74222063d__alles
deacons10310393de_acons
dealer74122143de_a_ler
dealers84118613de_a_lers
deals65435343de_a_l_s
dearies83526273de_aries
deashes113313903de_ashes
deaves105319533de_a_ves
debagged1433723debagged
debags104211063deba__gs
debarked16175823debarked
debarker15155503debarker
debarkers16164553debarkers
debarks14388493deba_rks
debarred12165633debarred
debars94218043deba__rs
debase94014473deba_se_
debased113310583deba_sed
debaser103510413deba_ser
debasers11377903debasers
debate94419193deba_te_
debated113916083deba_ted
debater104114693deba_ter
debaters113511923debaters
debauched18123343debauched
debauchee17123613debauchee
debauchees18122043debauchees
debaucher17123293debaucher
debauchers18122643debauchers
debones103315113deb_ones
debouches17124103debouches
debrides1268723debrides
debtless1135653deb_tless
debyes1238103deb__yes
decades113615513deca_des
decals93717713deca_l_s
decanes103118913deca_nes
decares102818533deca_res
decayless1542863decayless
deciles104417723de_ciles
deckles143312803de_ckles
decuples1395283decuples
deduces1168793deduc_es
deface123113863defac_e_
defaced142910973defac_ed
defacer132810363defac_er
defacers14237993defacers
defames132812253defa_mes
defaults1243333defaults
defiles114016843de_files
degames113312623dega_mes
degases93413103dega_ses
degasses10278363degasses
deices94119373de_ic_es
dekares122710873deka_res
delaines9312963delaines
delates83526283dela_tes
deles65139253de___les
demarches1745913demarches
denticles1237753denticles
derailed102410403derailed
derails84216393derail_s
deranges1039973deranges
derates84028893dera_tes
desalts839573desa_lts
detached1537733detached
detacher1437543detacher
detachers1536483detachers
detailed10319873detailed
detailer9268673detailer
detailers10257253detailers
details84214043detail_s
deuces94015513de_uc_es
devalues1235853devalues
devices133212583devic_es
dewaxes18297843dewa_xes
dibbles124013333dib_bles
diebacks1745963diebac_ks
disables11410903disables
drabbles13308523drabbles
durables11237013durables
eagles73819163_e_agles
enables92813123_enables
females12310663fema_les
fenagles12186083fenagles
leaches123319343le_aches
legacies1139043legacies
macles107023223__macles
manacles1239523manacles
measles92412753me_asles
menaces112715523menac_es
miracles1238333miracles
oracles93212423_oracles
peaces106324083pe_ac_es
peaches144120053pe_aches
pebbles1337573peb_bles
pedicles1338683pedicles
pentacles1338773pentacles
percales12313803percales
reaches123423203re_aches
reales64934123re_a_les
rebates95123183reba_tes
recycles1535353recycles
refaces123216743refac_es
regales83520793rega_les
relaces93420883relac_es
resales74724903resa_les
rescales103414573rescales
retables101712673retables
retackles1545363retackles
reticles103912483reticles
rubaces1139313rubac_es
teaches122718353te_aches
teazles16308923te_azles
tenaces92814513tenac_es
tentacles1146713tentacles
treacles1039703treacles
unbales92914863unba_les
vehicles16204683vehicles
vernacles1445073vernacles
vesicles13127073vesicles

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 Filter1786911461620.436409841.7
2DLD Change Limit1461621426.65621959.4
3Display Results1421420.0602366.7
 (SQL Overall)1786911427.15224984.8
 
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.