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

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

47 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
calcitonins156343(None) 
calcitonin1453921calcitonin_
calcedonies1652443calcedonies
calcimining1852453calcimining
calcining1447813calci__ning
calcinosis1444093calcinosi_s
alimonies1198334_al_imonies
antitoxins17117144_antitoxins
auctioning1344894_auctioning
balconies1347744balc__onies
calamondins1652454cal_amondins
calcicoles1344024calcico_les
calcicolous1451914calcicolous
calcifies1638924calci__fies
calcifying2144494calci_fying
calcimine1565414calci__mine
calcimines1674684calcimin_es
calcinations1647934calcinations
calcines12314754calci__n_es
calcinoses1445124calcino_ses
calcites12313004calcit___es
calcitic1148194calcit__i_c
calvities1438944calvit__ies
calypsonians196774calypsonians
cantoning12310884ca__ntoning
captioning1545704capti_oning
carcinogens1653364carcinogens
carcinoids1584454carcino_ids
cardiotonics1752054cardiotonics
cartoning12311114ca__rtoning
catatonias1255414ca_tatonias
catatonics1444604ca_tatonics
cautioning1345724cauti_oning
chalcedonies2061754chalcedonies
clarioning1345184clari_oning
claytonias1562864c_laytonias
clintonias1253254c_lintonias
clitoris1047874c_l_itori_s
digitonins12133204_digitonins
falconine1445174falc__onine
halitosis1245204hal_itosi_s
melatonins1245644mel_atonins
palimonies1445634pal_imonies
palmitins1346954palmit__ins
sanctioning1453994sanctioning
santonins948454sa__ntonins
saxitoxins1651714sa_xitoxins

Search took 10 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 Filter1786911488190.436409841.7
2DLD Change Limit148819479.43615771.4
3Display Results47470.0331424.2
 (SQL Overall)178691479.90518040.5
 
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.