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

120 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
cannulas103759(None) 
cannula937441cannula_
cannulae1046501cannulae
cannular1046291cannular
canulas9312861ca_nulas
annuals7388192_annuals
annular737702_annular
annuls64711732_annul_s
annulus7426612_annulus
candelas1139532candelas
canellas10310562canellas
canfuls1248422canful_s
cannas84518402cann__as
cannels93413362cannel_s
cannolis1037862cannolis
cannulate1148632cannulate
cannulates1247782cannulates
canolas9313992ca_nolas
cantalas104013522cantalas
canula8312972ca_nula_
canulae9311192ca_nulae
canular9310332ca_nular
ranulas7311782ra_nulas
aciculas12228563aciculas
angular838543_angular
anlas55626933_a_n_las
annals66415923_annal_s
annas55824883_ann__as
anneals7449953_anneals
annonas738793_annonas
annual64710703_annu_al
annul55813383_annul__
annulate8310923_annulate
annulet7311593_annulet
annulets845813_annulets
annuli6459053_annul_i
annulose844473_annulose
cabalas113516003ca_balas
cabbalas1467373cabbalas
caesuras1055743caesuras
calculus1255333calculus
calendulas1372023calendulas
callas84526753ca__llas
campanulas1652283campanulas
canals84421673ca_nal_s
canastas1037693canastas
cancels114113313cancel_s
canchas143212403ca_nchas
candela1089743candela_
candidas12338653candidas
candles104422343ca_ndles
canella9310793canella_
canful11610263canful__
cangues10611823cangu_es
canicular1346473canicular
canna75919333cann__a_
cannabis1266033cannabis
cannel84216403cannel__
cannelon1045123cannelon
cannelons1145213cannelons
canners93822663cann_ers
cannibal1245203cannibal
cannibals1354453cannibals
cannily1239263cannil_y
cannings113710333cannings
cannoli937263cannol_i
cannons94412883cann_ons
cannulated1346503cannulated
canola8313623ca_nola_
cantala94114673cantala_
cantals93919573cantal_s
cantatas103410093cantatas
cantinas102713783cantinas
cantles94721413ca_ntles
cantus85117763cantu__s
canulate10314553ca_nulate
canulates11312873ca_nulates
canvas113813333ca_n_vas
canzonas1935383canzonas
capfuls1436533capful_s
capsular1245413capsular
capsules1236633capsules
carfuls1249133carful_s
carnaubas1342923carnaubas
casuals91410543ca_suals
caulds95512383ca__ulds
caules85927253ca__ules
caulis85320083ca__ulis
caulks125611863ca__ulks
cauls75727773ca__ul_s
cavallas1366843cavallas
cedulas1058503c_edulas
channels13388503channel_s
cingula10327173cingula_
cingular11256983cingular
consular1038823consular
consuls92412323consul_s
consults10219983consults
copulas113811573c_opulas
maculas113114023ma_culas
mandalas1139443mandalas
mandolas1139133mandolas
manilas93915873ma_nilas
manillas102611163manillas
mannas85019803mann__as
mantuas93410993mantu_as
manuals9311223ma_nuals
panduras1136963panduras
panfuls1237183panful_s
pinnula934923pinnula_
pinnulae1044183pinnulae
pinnular1044433pinnular
pinnules1036473pinnules
radulas839583ra_dulas
ranula6311813ra_nula_
ranular739443ra_nular
sannups934463sannu_ps
scapulas1246143sca_pulas
vanillas11228123vanillas
zonulas1637023_zonulas

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.456391866.2
2DLD Change Limit1461621206.92021121.7
3Display Results1201200.0462608.7
 (SQL Overall)1786911207.42224075.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.