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

134 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
capabler143535(None) 
capable13313361capable_
cabler104519172c__abler
canaller1038952canaller
capablest1544882capablest
capably1639252capabl_y
abler75624313___abler
actable11313473actable_
ambler104916453_a_mbler
arable81821003_arable_
arables91814973_arables
babbler104012823ba_bbler
caballed1337163caballed
caballero1342883caballero
caber95126833c__ab_er
cable95329913c__able_
cabled114819873c__abled
cablers114416713c__ablers
cables104527553c__ables
cablet104429463c__ablet
cackler153812573ca_ckler
cadaster1136903cadaster
cadaver1335783cada_ver
cajoler16398393ca_joler
caliber1139733calib_er
callable12310753callable_
caller85125483c__aller
camailed1336553camailed
camber124418483ca_mb_er
canaled103615553cana_led
canalled1139573canalled
canallers1137213canallers
canceler12238913canceler
candler103516593ca_ndler
capelet11517073cap_elet
caper94831623cap___er
caperer113013403cap_erer
caplet104226813cap__let
capmaker1855203capmaker
caponier1237883caponier
capper124421983cap__per
capsomer1445773capsomer
capsular1245403capsular
capsule1137343capsule_
capsuled1334533capsuled
capsules1236623capsules
capturer1246093capturer
carabiner1346333carabiner
caracoler1346413caracoler
caroler93816753ca_roler
caroller1039203caroller
carpale113414353carpa_le_
carpooler1345313carpooler
cartable121314093cartable_
cascable141510623cascable_
cascables15165773cascables
cashable15159793cashable_
castable121613973castable_
catcaller1344813catcaller
causable1239973causable_
cavalero1344763cava_lero
cavalier1348173cavalier
caviler1249063ca_viler
caviller1337063caviller
citable11313463citable_
clabber134210113c_labber
coaler84121713c_oa_ler
cobbler133311823c_obbler
codable12311663codable_
copyable1736623copyable_
crabber133810733c_rabber
cradler102910513c_radler
crawler123510453c_rawler
culpable1436283culpable_
cupeler1177483cup_eler
cupeller1256103cupeller
curable112414513curable_
cymbaler1743113cymbaler
dabbler124012153da_bbler
datable101714233datable_
disabler1147913disabler
drapable1377573drapable_
dupable12238383dupable_
eatable91717603eatable_
eatables10169793eatables
empaler11288353empa_ler
enabler9299363_enabler
escapable1544983escapable_
fabler116115813__fabler
fadable13310463fadable_
gabbler124013303ga_bbler
gambler123612683ga_mbler
garbler104012563ga_rbler
hatable121713963hatable_
impaler11298393impa_ler
incapable1547563incapable_
japanner1743013japanner
lapsable12117383lapsable_
macaber1336163macab_er
makable15510203makable_
mappable1635923mappable_
marbler113511673ma_rbler
namable11312343namable_
paler75436933__pa_ler
palpable1448033palpable_
parable111819773parable_
parables121613563parables
payable141711323payable_
payables15166483payables
rabbler113514093ra_bbler
rambler113313263ra_mbler
ratable91717553ratable_
ratables10159723ratables
reapable12311393reapable_
ropable111611333ropable_
salable91415463salable_
savable121711863savable_
sayable121411613sayable_
scalable121710233scalable_
shapable15197803shapable_
spaller92713473_spaller
stabler94014933_stabler
takable13310193takable_
tamable11312853tamable_
tapeable1238823tapeable_
tappable1436343tappable_
taxable1639073taxable_
taxables1734383taxables
typable1435883typable_
uncapable1547783uncapable_
wabbler143511923wa_bbler
wadable13310233wadable_
warbler123211463wa_rbler
waxable1937673waxable_

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.1561145455.1
2DLD Change Limit1461621347.67319048.9
3Display Results1341340.0462913.0
 (SQL Overall)1786911347.87522690.9
 
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.