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

132 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
disabler114791(None) 
disable10516431disable_
disabled1248711disabled
disablers1255801disablers
disables11410901disables
diablery1443232di_ablery
dialer74315432di_a_ler
dialler848812di_aller
dibbler124510282di_bbler
disarmer1138032disarmer
disaster949942disaster
dismaler1137902dismaler
abler75624313___abler
advisable1544573advisable_
assailer844823assailer
bitable11312203bitable_
cabler104519173__cabler
capabler1435353capabler
citable11313463citable_
dabber114816963d__abber
dabbler124012153d_abbler
datable101714233datable_
dealer74122143d_ea_ler
demisable1448533demisable_
desalter938363desalter
detailer9268673detailer
devisable1546853devisable_
diablerie1243583di_ablerie
dialed84716453di_a_led
dialers83614303di_a_lers
dialled9510133di_alled
diallel845683di_allel
diallers957773di_allers
diaper94513113di_a_per
diaster82813313di_aster
dibber114614713di__bber
dibble114013843di_bble_
dibbled133510843di_bbled
dibblers13377583di_bblers
dibbles124013333di_bbles
didapper1442953didapper
diddler103511513di_ddler
dilater83515653dila_ter
dimmable1536113dimmable_
dippable1536123dippable_
disabling1337753disabling
disabuse1145553disabuse
disabused1344903disabused
disabuses1246203disabuses
disagree1048353disagree
disallow1243513disallow
disappear1442493disappear
disarmed1238643disarmed
disarmers1246943disarmers
disasters1039153disasters
disavower1643473disavower
disbar938513dis_b_ar
discarder1346753discarder
discolor1146423discolor
discover1439563discover
disenable1249673disenable_
disenabled1444913disenabled
disenables1346233disenables
dishier113613403dis_hier
disinter9310673disinter
disliker13358643disliker
disobey1346243disob_ey
disobeyer1542693disobeyer
disorder1038133disorder
dispeller12146983dispeller
disposer11310413disposer
disputer1137973disputer
disrober1147623disrober
dissembler1544313dissembler
dissever12107653dissever
dissolver1345623dissolver
distiller1046673distiller
doable93115243d_oable_
doubler103110083d_oubler
dowable13189453dowable_
drabber12438593d_rabber
drawler11338593d_rawler
dribbler13316313dribbler
drivable1438023drivable_
dryable13237433dryable_
dupable12238383dupable_
durable102312723durable_
durables11237013durables
dyable12308983d_yable_
dyeable1337303dyeable_
editable11310423editable_
enabler9299363_enabler
fabler116115813__fabler
finable122213623finable_
finagler12194953finagler
fishable1637593fishable_
fixable19218193fixable_
hidable1399403hidable_
hirable121612313hirable_
kissable1436853kissable_
liable81415813li_able_
likable13219413likable_
linable92214343linable_
listable10810313listable_
livable122010323livable_
losable91910953losable_
minable112315073minable_
misalter1038343misalter
misaver1249813misa_ver
miscaller1346283miscaller
missable12311533missable_
mixable18259173mixable_
nibbler11379273ni_bbler
nimbler11358063ni_mbler
posable112212783posable_
raisable10311643raisable_
ridable101412493ridable_
rinsable10310043rinsable_
risible937923risible_
risibles1035783risibles
saber75330243__sab_er
sable74732163__sable_
sables85026693__sables
sailer63526103__sailer
seisable10311373seisable_
sizable1839893sizable_
stabler94014933_stabler
unstabler1145623unstabler
usable84012553_usable_
viable111613773vi_able_
visible1236923visible_
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.406440125.6
2DLD Change Limit1461621327.51319454.5
3Display Results1321320.0632095.2
 (SQL Overall)1786911327.98222386.7
 
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.