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

162 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
capsule113734(None) 
capsuled1334531capsuled
capsules1236621capsules
capable13313362capable
capful1368172capful_
capfuls1436522capfuls
capsize2037622capsize
capsular1245402capsular
capsulate1347562capsulate
capsulize2293812capsulize
capture1138912capture
castle84918962ca_stle
cupule103410722cup_ule
encapsule1352282encapsule
papule102212132pap_ule
aisle55223193_ais_le
ampoule11116603ampoule
ampule10710613_ampule
apostle937853_apostle
apple94517673_ap_ple
appulse1134673_appulse
apse67725383_aps__e
assume897563_assume
assure6610773_assure
barbule1137943barbule
bascule1136573bascule
cable95329913ca__ble
cackle143416923ca_ckle
cadelle1039923cadelle
caesura956233caesura
caesurae1055123caesurae
caique17318803caiqu_e
cajole154011183ca_jole
calculi1146563calculi
calicle113111433calicle
calque17289843calqu_e
calycle14245833calycle
camisole1246173camisole
campsite1447413campsite
candle94321483ca_ndle
canful11610263canful_
canfuls1248423canfuls
cangue91012443cangu_e
cannula937433cannula
cannulae1046493cannulae
cansful1236833cansful_
cantle84522153ca_ntle
canula8312963ca_nula
canulae9311183ca_nulae
capabler1435353capabler
capably1639253capably
cape87242783cap___e
capelet11517073cap_elet
capitula1244983capitula
caplet104226813cap__let
capote10315733cap_ote
capouch1644413capouch
caprice1349683caprice
caprine11314233caprine
capriole1276913capriole
caps87147893caps___
capsid11312413caps_id
capsids1239333capsids
capsized2255493capsized
capsizes2147203capsizes
capsomer1445773capsomer
capstan1137903capstan
capstone1237653capstone
capsulated1545653capsulated
capsuling1444533capsuling
capsulized2482953capsulized
capsulizes2383293capsulizes
captive1438973captive
captured1336573captured
capturer1246093capturer
captures1239443captures
capuche1644433capuche
caput9823983cap_u_t
carful11610973carful_
carfuls1249133carfuls
cariole9818343cariole
carle74535703ca__rle
carouse9614423carouse
carpale113414353carpale
carse74934333cars__e
case65848083ca_s__e
casque17299273ca_sque
cassene93111543cassene
cassine93817283cassine
cassoulet1155333cassoulet
caste75932363ca_s_te
castled104311513ca_stled
castles94917733ca_stles
casual81112863ca_sual
casuals91410523ca_suals
casus76419253ca_su_s
catsuit959393catsuit
catsup1036433catsu_p
catsups1135343catsups
cattle85118903ca_ttle
caudle93912913ca_udle
caul65630003ca__ul_
cauld85318443ca__uld
caules85927253ca__ules
caulk115315453ca__ulk
cauls75727773ca__uls
causable1239973causable
causal81413203causal_
causals91411183causals
cause75225353ca__use
cayuse11207763ca_yuse
cellule936523cellule
censure92310603censure
chasuble1543063chasuble
ciboule1145093ciboule
closure9278483closure
coassume12103973coassume
console92715983console
consul82312303consul_
consuls92412313consuls
consult92513633consult
consume11510133consume
copse95623923cops__e
copula102812043cop_ula
copulae112810613cop_ulae
cupful1356423cupful_
cupfuls1444343cupfuls
cupsful1453433cupsful_
cupula10328433cup_ula
cupulae11347853cup_ulae
cupules113210263cup_ules
curule83614123c_urule
cypsela1442443cypsela
cypselae1542033cypselae
dapple1138853dap_ple
dapsone1038463dapsone
encapsuled1551803encapsuled
encapsules1452133encapsules
hassle93711593ha_ssle
lapful1156483lapful_
lapfuls1234503lapfuls
lapsable12117383lapsable
lapse74917683laps__e
lapsible1273973lapsible
lapsus8437273lapsu_s
macule104115273ma_cule
maple95521143map__le
papula103011113pap_ula
papulae11249353pap_ulae
papules112411573pap_ules
pule65040953__p_ule
rapture937393rapture
rassle63813203ra_ssle
rasure6311423ra_sure
saccule1136743saccule
scapula1136343scap_ula
scapulae1255433scap_ulae
spansule1043623spansule
taphole1239773taphole
valvule1343663valvule
warsle93112923wars_le
warstle10328013warstle

Search took 9 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 Filter1786911340270.423422437.4
2DLD Change Limit1340271627.57617691.0
3Display Results1621620.0463521.7
 (SQL Overall)1786911628.04522211.4
 
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.