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

73 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
capsulate134756(None) 
capsulated1545651capsulated
calculate1389872calculate
cannulate1148632cannulate
canulate10314552ca_nulate
capitulate1445102capitulate
capsular1245402capsula_r
capsule1137342capsul__e
capsulize2293812capsulize
consulate11612232consulate
copulate122614112cop_ulate
cupulate122810032cup_ulate
encapsulate1552832encapsulate
aciculate132510803aciculate
acidulate12256893acidulate
adulate8313233_a_dulate
ambulate1239733_ambulate
angulate9312013_angulate
annulate8310923_annulate
apholate13410473_apholate
apiculate13279883_apiculate
caesurae1055123caesura_e
calculated1577803calculated
calculates1498703calculates
campanulate1762403campanulate
cannulae1046493cannula_e
cannulated1346503cannulated
cannulates1247783cannulates
canulae9311183ca_nula_e
canulated12310673ca_nulated
canulates11312873ca_nulates
capitate121712183cap_itate
capitulated1644153capitulated
capitulates1554423capitulates
capsuled1334533capsul_ed
capsules1236623capsul_es
capsuling1444533capsuling
capsulized2482953capsulized
capsulizes2383293capsulizes
captivate1645923captivate
carpellate1445333carpellate
caseate9314783ca_s_eate
casemate1239843ca_semate
castrate10313863ca_strate
casualty1344473ca_sualty
caudate10311353ca__udate
cingulate12238603cingulate
circulate13810433circulate
coagulate1258083coagulate
consulates12711103consulates
copulae112810613cop_ula_e
copulated142710483cop_ulated
copulates132612463cop_ulates
crenulate1167693crenulate
cumulate123110223c_umulate
cupulae11347853cup_ula_e
cypselae1542033cypsela_e
encapsulated1752583encapsulated
encapsulates1652603encapsulates
fabulate1339203fa_bulate
hamulate1359013ha_mulate
insulate8312843_insulate
jaculate172311783ja_culate
maculate122815623ma_culate
papillate13127573papillate
papulae11249353pap_ula_e
populate122812093pop_ulate
rosulate8310903_rosulate
sacculate1349023sacculate
scapulae1255433scap_ula_e
scopulate1366543scop_ulate
spatulate11107173spatulate
tabulate10310893ta_bulate

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 Limit148641736.73622066.7
3Display Results73730.0461587.0
 (SQL Overall)178691737.20224811.3
 
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.