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

112 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
calamite1231253(None) 
calamine12314031calamine
calamites13410711calamites
calamity1547751calamity
catamite12510591catamite
calamata1247552calamata
calami10313422calami__
calamined1447432calamined
calamines13312222calamines
calamint12315132calamint
calamints1348052calamints
calamities1448472calamities
calcite11413782cal_cite
catamites1349362catamites
malamute1245892malamute
rolamite1048742rolamite
adamsite1144423_adamsite
agamete1037403_agamete
alamode1038153_alamode
alanine7316863_alanine
alate55340323_ala__te
albite8313313_al_bite
allanite8411093allanite
alumine9412693_alumine
alunite7311633_alunite
apatite9312963_apatite
bedlamite1443193bedlamite
caladium1347023caladium
calamar1149293calam_ar
calamari1246123calamari
calamars1238133calamars
calamary1545463calamary
calamatas1345783calamatas
calamitous1443383calamitous
calamus1139243calam_us
calcarate1347703calcarate
calceate1239863calceate
calcimine1565413calcimine
calcine11315273cal_cine
calcites12313003cal_cites
calflike1735153calflike
califate13310483califate
calmative1647033calmative
calming123915973cal_ming
calorie92716893calori_e
calorize192712733calorize
calotte9510563cal_otte
calumet11313293calumet_
calumets1236283calumets
calumniate1444103calumniate
calycate1537893calycate
calycine1546963calycine
camise103319633c__amise
cammie124615293ca_mmi_e
camomile14156323camomile
campsite1447413campsite
canalise10816213canalise
canalize19914493canalize
capacity1746023capacity
carabine12412393carabine
carate84734003cara__te
carbamate1546023carbamate
carbamide1645743carbamide
carmine112918483ca_rmine
casemate1239843casemate
casimire1244773casimire
cavatine13310323cavatine
cellmate1237873cellmate
ceramide1347973ceramide
chabazite25122743chabazite
chamise143612853c_hamise
chlorite133012843chlorite
chromite15310833chromite
clamlike1635163c_lamlike
clarity12310913c_larity
clavate1238713c_lavate
climate11312833c_limate
columbite1543973columbite
cyanamide1743343cyanamide
cyanite122710763c_yanite
cyclamate1843793cyclamate
dolomite1148133dolomite
dynamite1444813dynamite
fayalite1447053fayalite
galenite91210063galenite
gallamine1246123gallamine
halite93624233hal__ite
kalamata1445273kalamata
kamacite1645293kamacite
lamiae84817453__lamiae
malachite1666023malachite
malaise9312673mala_ise
malamutes1345373malamutes
malate84624553mala__te
malemute1244923malemute
marmite112413993ma_rmite
maximite1955853maximite
melamine12310303melamine
melanite10512033melanite
nialamide1252763nialamide
palate84226783pala__te
palatine10316063palatine
palmate113215233pal_mate
parakite14410423parakite
parasite10314843parasite
rolamites1148243rolamites
salacity1347853salacity
salami8313103salami__
salamis9313513salami_s
samite83020603__samite
stalagmite1351983stalagmite
zaratite1747793zaratite

Search took 9 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.420425454.8
2DLD Change Limit1461621127.67319048.9
3Display Results1121120.0462434.8
 (SQL Overall)1786911128.13921954.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.