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

159 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
canulates1131287(None) 
cannulates1247781cannulates
canulate10314551canulate_
canulated12310671canulated
adulates9311912_adulates
angulates10310862_angulates
calculates1498702calculates
cannulate1148632cannulate_
cannulated1346502cannulated
canulae9311182canula_e_
canulas9312852canula__s
caudates11310262ca_udates
coagulates13137452coagulates
conflates14311132conflates
consulates12711102consulates
copulates132612462copulates
cumulates13258972cumulates
cyanurates1543562cyanurates
fabulates1447732fabulates
granulates1148462granulates
jaculates182810362jaculates
maculates132013722maculates
tabulates1139142tabulates
ablates92416903_a_blates
acidulates13215843acidulates
acrylates1446683acrylates
actuates10310313actu_ates
acylates1339743_acylates
adulate8313233_adulate_
adulated1039753_adulated
alates64833973_a__lates
ambulates1348383ambulates
analytes11169203_analytes
angulate9312013_angulate_
angulated1139223_angulated
animates101316423_animates
anlaces92313733_an_laces
anlages82414113_an_lages
anlases72514903_an_lases
annates72415423_an_nates
annulate8310923annulate_
annulated1038603annulated
anolytes11169213_anolytes
bandmates1447923bandmates
calculate1389873calculate_
calculated1577803calculated
califates14310113califates
canalises11515493canalises
canalizes201113783canalizes
canapes111213083can__apes
candidates1446303candidates
candles104422343candl__es
canewares1447363canewares
cannulae1046493cannula_e_
cannulas1037583cannula__s
canolas9313993canola__s
cantatas103410093can_tatas
cantillates1346633cantillates
cantles94721413cantl__es
canula8312963canula___
canular9310323canula__r
canulating1349553canulating
canvases13349523can_vases
capitulates1554423capitulates
capsulate1347563capsulate_
capsulated1545653capsulated
carates95630613ca__rates
caseates10313713ca_seates
casemates1349523casemates
castrates11312683castrates
casualties1244753casualties
catalases1149443catalases
catenates11311813catenates
caudate10311353ca_udate_
caudated1238063ca_udated
caules85927253ca_ul__es
cavitates14168963cavitates
chelates132713853c_helates
cholates132414763c_holates
cingulate12238603cingulate_
circulates1489283circulates
coagulases13133323coagulases
coagulate1258083coagulate_
coagulated1496533coagulated
collates103019143c_ollates
conclaves1646543conclaves
conepates13912283conepates
conflate13311173conflate_
conflated1539333conflated
conjugates2044693conjugates
consulate11612233consulate_
copulate122614113copulate_
copulated142710483copulated
corelates11314863corelates
craniates11310653cran_iates
crenelates1266193crenelates
crenulate1167693crenulate_
crenulated1356043crenulated
cumulate123110223cumulate_
cumulated14237843cumulated
cupulate122810033cupulate_
curates95323833c__urates
cyanates13238433cyan__ates
cyanurate1443993cyanurate_
denudates1145583denudates
ejaculates19166443ejaculates
emulates10312573_emulates
fabulate1339203fabulate_
fabulated1546323fabulated
gallates92815533ga_llates
granulate1059183granulate_
granulated1256943granulated
granulites1146623granulites
gratulates1157133gratulates
hamulate1359013hamulate_
haulages1236623ha_ulages
inflates11512193_inflates
insulates9311843insulates
inulases838763_inulases
jaculate172311783jaculate_
jaculated19289053jaculated
jugulates1744603jugulates
lazulites1844253lazulites
lunulate838253lunulate_
lunulated1036783lunulated
maculate122815623maculate_
maculated142411503maculated
malates93522613ma__lates
mandates11314093man_dates
manducates1545593manducates
manipulates1544633manipulates
maturates11311763maturates
modulates1238053modulates
nutates73214973__nutates
osculates11109393osculates
ovulates1148523_ovulates
palates93624943pa__lates
peculates132112543peculates
planulate1146903planulate_
populates132710673populates
ranulas7311783ranula__s
regulates101211723regulates
sanitates9611733sanitates
saturates9811603saturates
simulates1139853simulates
sinuates8310963sinu_ates
tabulate10310893tabulate_
tabulated1237303tabulated
tannates81911953tan_nates
tantalates10106703tantalates
tinplates1147773tinplates
translates10411703translates
tubulates1147233tubulates
ululates848433_ululates
undulates1048923undulates
ungulates1048353ungulates
valuates112811203valu_ates
vanadates1345133vanadates
xanthates1945653xanthates

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.423422437.4
2DLD Change Limit1486411597.28320409.3
3Display Results1591590.0632523.8
 (SQL Overall)1786911597.76923000.5
 
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.