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

101 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
capsuled133453(None) 
capsule1137341capsule_
capsules1236621capsules
capsized2255492capsized
capsular1245402capsular
capsulated1545652capsulated
capsulized2482952capsulized
captured1336572captured
castled104311512ca_stled
encapsuled1551802encapsuled
aisled74516183_ais_led
assumed1065293_assumed
assured858373_assured
caballed1337163caballed
cabled114819873ca__bled
cackled164613303ca_ckled
cajoled17428283ca_joled
called94126733ca__lled
callused1135853callused
calqued19306523calqu_ed
camailed1336553camailed
campused1535253campused
canaled103615563ca_naled
canalled1139583canalled
canceled13279403canceled
candled113815743ca_ndled
capable13313363capable_
capabler1435353capabler
caped104931803cap___ed
capelet11517073cap_elet
capered123014043cap_ered
capful1368173capful__
capfuls1436523capful_s
caplet104226813cap__let
capped134721853cap__ped
caprioled1464743caprioled
capsid11312413caps__id
capsize2037623capsize_
capsizes2147203capsizes
capsomer1445773capsomer
capsulate1347563capsulate
capsuling1444533capsuling
capsulize2293813capsulize
capsulizes2383293capsulizes
capture1138913capture_
capturer1246093capturer
captures1239443captures
capuched1843743capuched
caroled103717693ca_roled
carolled1138833carolled
caroused1149253caroused
carpooled1445073carpooled
cased86032413ca_s__ed
cashed125124353ca_s_hed
casked134815513ca_s_ked
casqued19235633ca_squed
cassoulet1155333cassoulet
castle84918963ca_stle_
castles94917733ca_stles
caucused1344093caucused
cauld85318443ca__ul_d
caules85927253ca__ules
caulked14486673ca__ulked
caused95117043ca__used
caviled1348723ca_viled
cavilled1436733cavilled
censured11248913censured
censused11184973censused
chiseled1435883chiseled
closured11266353closured
coassumed14112933coassumed
consoled112911453consoled
consulted1277923consulted
consumed1337923consumed
cupeled1257793cup_eled
cupelled1365743cupelled
cupule103410723cup_ule_
cupules113210263cup_ules
dappled1336393dap_pled
easeled8159863ea_seled
encapsule1352283encapsule_
encapsules1452133encapsules
hanseled1237713hanseled
hassled11358303ha_ssled
hauled104415213ha__uled
lapeled10258893lap_eled
lapelled11227083lapelled
lapsed94712583laps__ed
maculed123510053ma_culed
mauled94817823ma__uled
papule102212133pap_ule_
papules112411573pap_ules
puled84926523__p_uled
rappeled1335003rappeled
raptured1155473raptured
rassled83310453ra_ssled
tasseled935603tasseled
vapoured1434353vapoured
warsled112910443wars_led
warstled12286123warstled
wauled104713963wa__uled

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.423422437.4
2DLD Change Limit1461621017.35619869.8
3Display Results1011010.0333060.6
 (SQL Overall)1786911017.81222873.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.