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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

76 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
cannulate114863(None) 
annulate8310921_annulate
cannulae1046501cannula_e
cannulated1346501cannulated
cannulates1247781cannulates
canulate10314551ca_nulate
angulate9312012_angulate
annulated1038602_annulated
calculate1389872calculate
cannula937442cannula__
cannular1046292cannula_r
cannulas1037592cannula_s
canulae9311192ca_nula_e
canulated12310672ca_nulated
canulates11312872ca_nulates
capsulate1347572capsulate
cingulate12238602cingulate
consulate11612232consulate
crenulate1167692crenulate
pinnulate1145762pinnulate
aciculate132510803aciculate
acidulate12256893acidulate
adulate8313233_a_dulate
ambulate1239733_ambulate
angulated1139223_angulated
angulates10310863_angulates
annotate877713_annotate
annular737703_annula_r
annulet7311593_annulet_
annulets845813_annulets
annulose844473_annulose
calculated1577803calculated
calculates1498703calculates
campanulate1762403campanulate
candidate1356663candidate
cannonade12123953cannonade
cannulating1446013cannulating
cantillate1247343cantillate
canula8312973ca_nula__
canular9310333ca_nula_r
canulas9312863ca_nula_s
capitulate1445103capitulate
capsulated1545663capsulated
caudate10311353ca__udate
circulate13810433circulate
coagulate1258083coagulate
conflate13311173c_onflate
conjugate1945013conjugate
connate9315753conn__ate
consulates12711103consulates
copulate122614113c_opulate
crenelate1176513crenelate
crenulated1356043crenulated
cumulate123110223c_umulate
cupulate122810033c_upulate
cyanurate1443993cyanurate
fabulate1339203fa_bulate
granulate1059183granulate
hamulate1359013ha_mulate
insulate8312843_insulate
jaculate172311783ja_culate
lingulate10368193lingulate
lunulate838253_lunulate
maculate122815623ma_culate
manducate1445773manducate
manipulate1445163manipulate
pandurate1245883pandurate
paniculate1447213paniculate
pinnulae1044183pinnula_e
planulate1146913planulate
sacculate1349023sacculate
tabulate10310893ta_bulate
tannate71813523tann__ate
tantalate9107373tantalate
undulate9310403_undulate
ungulate939803_ungulate

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 Filter1786911486410.420425454.8
2DLD Change Limit148641766.95321378.0
3Display Results76760.0302533.3
 (SQL Overall)178691767.40324137.6
 
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.