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 “cabled” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

160 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
cabled11481987(None) 
abled86926831_abled
cabbed135416261cabbed
cable95329911cable_
cabler104519171cabler
cables104527551cables
cablet104429461cablet
called94126731called
fabled124216381fabled
gabled105518451gabled
tabled94020041tabled
abed79734132_ab_ed
able66340532_able_
abler75624312_abler
ables75935542_ables
ailed66240282_ailed
ambled115116372ambled
axled135315812_axled
babbled113612862babbled
babied114913512babied
bailed94726652bailed
baled85436442ba_led
balled94926892balled
bawled124415692bawled
bled75729312__bled
caballed1337162caballed
caber95126832cab_er
cabined1239992cabined
cablers114416712cablers
cablets114216342cablets
cabmen123610652cabmen
cached145419202cached
cackled164613302cackled
cadged114812342cadged
caged95426362ca_ged
cajoled17428282cajoled
caked126128622ca_ked
calked134617402calked
callee84327292callee
caller85125482caller
callet84536762callet
calmed114816382calmed
calved125215452calved
camlet104426582camlet
camped134720232camped
canaled103615562canaled
candled113815742candled
caned85838092ca_ned
canned95022062canned
canoed94618962canoed
canted94825782canted
caped104931802ca_ped
caplet104226812caplet
capped134721852capped
carded105424902carded
cared86050092ca_red
caried94528692caried
carked134024822carked
carle74535702carle_
carles85435082carles
caroled103717692caroled
carped115923762carped
carted98631442carted
carved124320852carved
cased86032412ca_sed
cashed125124352cashed
casked134815512casked
castled104311512castled
catted95422472catted
cauld85318442caul_d
caules85927252caules
caulked14486672caulked
caused95117042caused
caved116227562ca_ved
caviled1348722caviled
cawed116627062ca_wed
ceiled94114952ceiled
celled94420322celled
coaled95022712coaled
cobbled143411632cobbled
coble94823172coble_
cobles104622882cobles
coiled95123942coiled
coled85540762c_oled
cooled95224592cooled
cowled125218392cowled
craaled10339422craaled
crabbed14388872crabbed
cradled113410812cradled
crawled133710402crawled
cubed105519702cub_ed
culled94022472culled
curled95021652curled
cycled1436542cycled
dabbed124416142dabbed
dabbled133712072dabbled
eagled82914042eagled
enabled102510632enabled
fable105824752fable_
fabler116115812fabler
fables114921672fables
failed105421602failed
gabbed125216892gabbed
gabbled134112452gabbled
gable85325522gable_
gables94222332gables
galled84622862galled
gambled134112162gambled
gaoled84814502gaoled
garbled114512802garbled
hailed104122742hailed
haled95335822ha_led
hauled104415212hauled
jabbed184213482jabbed
jailed144917422jailed
labeled102510562labeled
ladled85013482ladled
lalled74218752lalled
macled116718112macled
mailed95326752mailed
malled94626112malled
marbled123212112marbled
marled95523162marled
mauled94817822mauled
mobled113213182mobled
nabbed115113612nabbed
nailed74021492nailed
naled65525052na_led
paled85538722pa_led
palled94625162palled
parled94626292parled
rabbled123514422rabbled
railed74727542railed
rambled123913522rambled
sabbed114518082sabbed
sabed86526812sab_ed
sable74732162sable_
sables85026692sables
sabred95916532sabred
sailed74327762sailed
scabbed14408222scabbed
scabbled15156302scabbled
scaled94822442sca_led
stabled103514952stabled
tabbed114215362tabbed
table75429602table_
tables84524892tables
tablet84227642tablet
tabued94310402tabued
tailed74424662tailed
vailed104619292vailed
wabbled153311442wabbled
wailed104823592wailed
waled94331002wa_led
walled104021292walled
wambled153610752wambled
warbled133212162warbled
wauled104713962wauled
wawled133811702wawled
yawled13459982yawled

Search took 3 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 Filter178691825510.343520965.0
2DLD Change Limit825511602.31335690.0
3Display Results1601600.0463478.3
 (SQL Overall)1786911602.70266132.9
 
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.