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

113 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
caponize213911(None) 
canonize1959831canonize
caponized2347071caponized
caponizes2238701caponizes
agonize172911402_agonize
calorize192712732calorize
canonise10511092canonise
canonized2147682canonized
canonizer2046692canonizer
canonizes2049592canonizes
caponier1237882caponier
capsize2037622cap_size
carbonize22169042carbonize
colonize192312772colonize
japanize2645282japanize
saponine1039222saponine
saponite10410532saponite
vaporize22239172vaporize
weaponize2364402weaponize
aconite9315473_aconite
agenize172910153_agenize
agnize16329563_a_gnize
agonise83112693_agonise
agonized19258993_agonized
agonizes182610583_agonizes
anodize1738683_anodize
aphorize2249043_aphorize
apprize2038183_apprize
atomize183111823_atomize
azotize1537083_azotize
baptize2036983bap_tize
calorie92716893calori_e
calorized21249663calorized
calorizes202312293calorizes
camomile14156323camomile
campanile1544403campanile
canalize19914493canalize
canine83826703ca__nine
cannie83819363ca_nni_e
canonic11312933canoni_c
canonised1256713canonised
canonises11410803canonises
canonist10513533canonist
canonizers2144413canonizers
capiz18514563cap__iz_
capizes20410373cap__izes
capoeira1243353capoeira
capon95221873capon___
caponata1245163caponata
caponiers1345733caponiers
caponizing2446983caponizing
capons104119503capon__s
capote10315733capo__te
caprice1349683cap_rice
caprine11314233cap_rine
capsized2255493cap_sized
capsizes2147203cap_sizes
capsulize2293813capsulize
captive1438973cap_tive
carbolize22189173carbolize
carbonized24157053carbonized
carbonizes23148613carbonizes
carnie84421093ca_rni_e
chromize2447683chromize
cognize1957683c_ognize
colonise102514283colonise
colonized212710433colonized
colonizer20309283colonizer
colonizes202613183colonizes
colorize192314203colorize
conine84528553c__onine
creolize1947183creolize
cutinize1948533cutinize
deionize1858683deionize
demonize20311533demonize
ebonize1838153_ebonize
euphonize2345033euphonize
harmonize23137713harmonize
ionize154613873__ionize
ironize16610373_ironize
japanized2844733japanized
japanizes2745163japanizes
japonica19114033japonica
jargonize2645293jargonize
jarovize2743763jarovize
latinize17610563latinize
lionize1668823_lionize
masonite1049683masonite
matronize2067183matronize
opsonize19114993opsonize
ozonize1546293_ozonize
paganize2048633paganize
patinize19610773patinize
patronize2077193patronize
pavonine1346663pavonine
peptonize2246563peptonize
salinize1739683salinize
saponify1644183saponify
saponin9310263saponi_n
saponines1148043saponines
saponins1039453saponins
saponites1139943saponites
scapolite1346243scapolite
simonize1947813simonize
taconite1049313taconite
unionize1747063unionize
valorize20239613valorize
vaporise13209633vaporise
vaporized24227353vaporized
vaporizer23236143vaporizer
vaporizes23228523vaporizes
weaponized2553993weaponized
weaponizes2464253weaponizes

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.423422437.4
2DLD Change Limit1461621136.64022012.3
3Display Results1131130.0462456.5
 (SQL Overall)1786911137.10925135.9
 
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.