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

155 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
cannula93743(None) 
cannulae1046491cannulae
cannular1046281cannular
cannulas1037581cannulas
canula8312961ca_nula
annual64710702_annual
annul55813382_annul_
annular737692_annular
annuli6459052_annuli
annuls64711732_annuls
candela1089742candela
canella9310792canella
canful11610262canful_
canfuls1248422canfuls
canna75919332cann__a
cannel84216402cannel_
cannels93413362cannels
cannily1239262cannily
cannoli937262cannoli
cannulate1148632cannulate
canola8313622ca_nola
cantala94114672cantala
canulae9311182ca_nulae
canular9310322ca_nular
canulas9312852ca_nulas
cingula10327162cingula
pinnula934912pinnula
ranula6311812ra_nula
acicula11228133acicula
alula5317093_a_lula
angular838533_angular
anna45529013_ann__a
annal56520763_annal_
annals66415923_annals
anneal64812293_anneal
annona648873_annona
annuals7388193_annuals
annulate8310923_annulate
annulet7311593_annulet
annulus7426613_annulus
bacula103112673ba_cula
biannual1043323biannual
cabala103516913ca_bala
cabbala1367183cabbala
caesura956223caesura
calculi1146553calculi
calendula1271973calendula
calla74827073ca__lla
campanula1542523campanula
canal75428043ca_nal_
canals84421663ca_nals
canasta938363canasta
cancel105316683cancel_
cancels114113313cancels
cancha134411613ca_ncha
candelas1139533candelas
candida114110253candida
candle94321483ca_ndle
canellas10310563canellas
cangue91012443cangu_e
cangues10611823cangues
canicular1346463canicular
cannas84518403cann_as
canned95022063cann_ed
cannelon1045123cannelon
canner84625983cann_er
canners93822663canners
cannery123610013cannery
cannibal1245203cannibal
cannie83819363cann_ie
cannier94014163cannier
canning103620133canning
cannolis1037863cannolis
cannon84514443cann_on
cannons94412883cannons
cannot83616773cann_ot
cannulated1346503cannulated
cannulates1247783cannulates
canny105817693cann__y
canolas9313993ca_nolas
cansful1236823cansful_
cantal84122033cantal_
cantalas104013523cantalas
cantals93919573cantals
cantata93811813cantata
canthal12410053canthal
cantina93417253cantina
cantle84522153ca_ntle
cantus85117763cantu_s
canulate10314553ca_nulate
canzona1836073canzona
capful1368173capful_
capfuls1436523capfuls
capitula1244983capitula
capsular1245403capsular
capsule1137343capsule
carful11610973carful_
carfuls1249133carfuls
carnal83919203carnal_
carnauba1252733carnauba
casual81112863ca_sual
caul65630003ca__ul_
cauld85318443ca__uld
caulk115315453ca__ulk
cauls75727773ca__uls
cavalla1257883cavalla
cedula977643c_edula
censual937663censual
channel123910483channel_
channels13388493channels
cingular11256963cingular
coagula1045403coagula
consul82312303consul_
consular1038813consular
consuls92412313consuls
consult92513633consult
copula102812043c_opula
cornua85411903cornu_a
cornual94210173cornual
cupula10328433c_upula
facula112912233fa_cula
frenula1045623frenula
hangul1049213hangul_
lingula8428793lingula
lunula636173_lunula
macula103013673ma_cula
mandala10310203mandala
mandola1039023mandola
manful11610213manful_
manila84518303ma_nila
manilla93012473manilla
manna75522533mann__a
mantua84412023mantu_a
manual8313463ma_nual
pandura1037143pandura
panful1179743panful_
panfuls1237173panfuls
papula103011113pa_pula
pinnulae1044183pinnulae
pinnular1044433pinnular
pinnule936003pinnule
planula935773planula
radula749313ra_dula
ranular739433ra_nular
ranulas7311773ra_nulas
sannup836563sannu_p
sannups934463sannups
scapula1136343sca_pula
spinula9257903spinula
ungula737603_ungula
valvula1343253valvula
vanilla10238743vanilla
vascula1245853vascula
vincula1246393vincula
zonula1537223_zonula

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 Filter1786911340270.1561145455.1
2DLD Change Limit1340271556.90619407.3
3Display Results1551550.0632460.3
 (SQL Overall)1786911557.12525079.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.