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

207 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
disables1141090(None) 
disable10516431disable_
disabled1248711disabled
disabler1147911disabler
disablers1255801disablers
dibbles124013332di_bbles
disabuse1145552disabuse
disabuses1246202disabuses
disenables1346232disenables
durables11237012durables
risibles1035782risibles
sables85026692__sables
ables75935543___ables
advisable1544573advisable_
aisles64721143ais__les
arables91814973_arables
bibles104617643bi__bles
bitable11312203bitable_
cables104527553__cables
cascables15165773cascables
citable11313463citable_
dabbles124514773d_abbles
dales66439743d__a_les
dalles74222063d__alles
datable101714233datable_
debacles1335723debacles
demisable1448533demisable_
desalts839573desa_lts
desirables1344213desirables
devisable1546853devisable_
diabase1037113di_abase
diabases1137223di_abases
diabetes1147023di_abetes
diablery1443233di_ablery
diabolos1174643di_abolos
dialed84716453di_a_led
dialer74315433di_a_ler
dialers83614303di_a_lers
dialled9510133di_alled
diallel845683di_allel
dialler848813di_aller
diallers957773di_allers
dials64925343di_a_l_s
diaries83321953di_aries
diastoles1047493diastoles
diazoles1836323diazoles
dibble114013843di_bble_
dibbled133510843di_bbled
dibbler124510283di_bbler
dibblers13377583di_bblers
diddles103915073di_ddles
digamies1238643digamies
dilates83220663dila_tes
dimmable1536113dimmable_
dimples122813213di_mples
dindles93817243di_ndles
dingles93818323di_ngles
dipoles101013753di_poles
dippable1536123dippable_
dipsades1246493dipsa_des
disabling1337753disabling
disabused1344903disabused
disagree1048353disagree
disagrees1146403disagrees
disallow1243513disallow
disallows1343393disallows
disarmed1238643disarmed
disarmer1138033disarmer
disarmers1246943disarmers
disarms1039043disa_rms
disaster949943disaster
disasters1039153disasters
disavows1544043disavows
disbands1237353disbands
disbars10310323dis_bars
disbuds11125243dis_buds
discases112014503discases
disciples1446403disciples
discuses113112863discuses
diseases92415813diseases
disenable1249673disenable_
disenabled1444913disenabled
diseuses93112763diseuses
dishabilles17132523dishabilles
dishelms1444723dishelms
dishes104622653dis__hes
dislikes132810843dislikes
dismaler1137903dismaler
dismalest1246313dismalest
dismals102010243dismal_s
dismantles1344333dismantles
dismes95617673dis__mes
disobey1346243disob_ey
disobeys1443683disobeys
disobliges1453073disobliges
dispels10310503dispel_s
disposables1653633disposables
disposes11313823disposes
disputes1139653disputes
disrates91118153disrates
disrobes1139743disrobes
dissaves1239413dissaves
dissembles1545083dissembles
disses75225963dis__ses
dissolves1346233dissolves
distances12311653distances
distastes1039633distastes
distaves12311403distaves
distills9319043distills
distils83015803distil_s
distomes11314163distomes
disuses84015413dis_uses
disvalues1344503disvalues
disyllables1752953disyllables
disyokes1656503disyokes
doable93115243d_oable_
dosages92310803dosa_ges
doubles103113353d_oubles
dowable13189453dowable_
dowsabels1541703dowsabels
drabbles13308523drabbles
dribbles13348393dribbles
drinkables1741943drinkables
drivable1438023drivable_
drumbles13277723drumbles
dryable13237433dryable_
dupable12238383dupable_
durable102312723durable_
dyable12308983d_yable_
dyeable1337303dyeable_
eatables10169793eatables
edibles1048003edi__bles
editable11310423editable_
educables1443473educables
enables92813123_enables
fables114921673__fables
fimbles143510663fi_mbles
finable122213623finable_
finagles12237553finagles
finales104016013fina_les
fishable1637593fishable_
fixable19218193fixable_
gables94222333__gables
giftables1572593giftables
gisarmes1144433gisarmes
gustables12165223gustables
hidable1399403hidable_
hirable121612313hirable_
isles54220563_is__les
istles62814983_is_tles
kibbles153510253ki_bbles
kissable1436853kissable_
liable81415813li_able_
likable13219413likable_
linable92214343linable_
lisles63416283lis__les
listable10810313listable_
livable122010323livable_
losable91910953losable_
minable112315073minable_
miracles1238333miracles
misallies1148383misallies
miserables1445613miserables
misfiles133110983misfiles
mislabels13114313mislabels
misrules1039383misrules
missable12311533missable_
missiles103015083missiles
mixable18259173mixable_
movables15175573movables
nibbles114011693ni_bbles
notables10178243notables
parables121613563parables
payables15166483payables
pistoles102514723pistoles
posable112212783posable_
potables12179703potables
raisable10311643raisable_
ratables10159723ratables
resales74724903resa_les
restables111511423restables
retables101712673retables
reusables1175223reusables
ridable101412493ridable_
rinsable10310043rinsable_
risible937923risible_
rissoles839113rissoles
sabes76437463__sab_es
sable74732163__sable_
sabres85520863__sabres
sales56055593__sa_les
seisable10311373seisable_
sisals63013573sisa_l_s
sizable1839893sizable_
stables93219073_stables
tables84524893__tables
taxables1734383taxables
timbales12227843timbales
tisanes7311853tisa_nes
usable84012553_usable_
viable111613773vi_able_
visages1138693visa_ges
visible1236923visible_
vocables15145733vocables
washables17144743washables
wimbles143010853wi_mbles
wirable121610963wirable_

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.453394461.4
2DLD Change Limit1461622077.40619735.6
3Display Results2072070.0932225.8
 (SQL Overall)1786912077.95222471.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.