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

160 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
tantric93959(None) 
mantric11311351mantric
antic75728862_ant_ic
anuric8812112_anuric
cantic103920542cant_ic
cantrip112910042cantrip
centric11312402centric
gastric1038642gastric
iatric8312172ia_tric
mantic104120902mant_ic
tactic10612752tact_ic
tannic82811472tan_nic
tanrec837802tan_rec
tantalic1048052tantalic
tantra63713352tantr_a
tantras73112092tantras
tantrism1048372tantrism
tantrum946682tantrum
tartaric1047062tartaric
xanthic1945862xanthic
acentric1247533acentric
agaric93513643_agaric
amtrac10109133_amtrac
anemic102713693_anemic
anergic1048113_anergic
anisic8313793_anisic
anodic92813133_anodic
anomic102516303_anomic
anoxic152610673_anoxic
anti45536363_ant_i_
antick124814583_ant_ick
antics84621453_ant_ics
antis55033313_ant_is
antra56521923_antr_a
antral65719413_antral
antre55224523_antr_e
antres65021003_antres
antrum8611313_antrum
anuria6313123_anuria
aortic8316613_aortic
astrict9614793_astrict
atactic11410083atact_ic
atria56022343_a_tria
atrip75315753_a_trip
attic75618353_a_ttic
attrit6315753_attrit
auric74521743_a_uric
baldric12166403baldric
baric96125693ba__ric
bawdric15164583bawdric
benthic1437473benthic
caloric113413223caloric
cambric1537393cambric
canonic11312933canonic
canopic1338803canopic
canthi11310973canthi_
cantraip12326393cantraip
cantrap113310283cantrap
cantrips12318933cantrips
capric12411803ca_pric
citric102812313_citric
daric85623123da__ric
daturic1047033daturic
dineric10310973dineric
enatic8317563enat_ic
enteric9314213_enteric
fabric1337833fa_bric
fanatic12610703fanatic
fanfic1436313fan_fic
fantail10310233fantail
frantic12310373frant_ic
gantries91413793gantries
gantry103810113gantr_y
gastrin839833gastrin
generic101310753generic
gentrice1148813gentrice
gnathic1344843gnathic
haptic13511893hapt_ic
lactic10713493lact_ic
latria62313603la_tria
lentic83515743lent_ic
mandril1049353mandril
manic94629443man__ic
mantid93820383mant_id
mantis83926033mant_is
mantra84116093mantr_a
mantram114011603mantram
mantrap11379823mantrap
mantras93815863mantras
mastic103119173mast_ic
matrix1539853ma_trix
metric10314683_metric
naric76824173__naric
nastic82915973nast_ic
nitric82512063_nitric
ontic74418573_ont_ic
panic93923903pan__ic
pantie84326473pant_ie
pantries101817393pantries
pantropic1547753pantropic
pantry115014103pantr_y
quantic18279063quant_ic
sangria838113sangria
santalic1048893santalic
santeria8311653santeria
santir6315253sant_ir
santirs7312963santirs
satiric939253satiric
satyric1237503satyric
stannic936663stan_nic
stanzaic1943363stanzaic
static83118683sta_t_ic
tabetic1138463tabetic
taborin92210453taborin
tactics1149323tact_ics
talaria7412523talaria
tamari8313413tamari_
tamarin9311923tamarin
tamaris9413603tamaris
tangram1038073tangram
tannin62613923tan_nin
tanrecs934823tan_recs
tantara72410823tantara
tantaras8269543tantaras
tantivy1335563tantivy
tanto55724943tant__o
tantrisms1146323tantrisms
tantrums1045113tantrums
tanuki1034913tanuki_
tanukis1134713tanukis
taroc75721643ta__roc
tattie64817513ta_ttie
taxemic1835243taxemic
taxitic1637093taxitic
tectrix1644263tectrix
tendril836783tendril
tenrec837513ten_rec
tentie62521183tent_ie
tentoria8119263tentoria
tetri52716453t_etri_
tetris62816293t_etris
theatric1346143theatric
thetic11412893thet_ic
thoric114314043t_horic
tonemic11310173tonemic
tonetic9313433tonetic
tonic74727653ton__ic
toric76529313t__oric
tortrix1444193tortrix
tunic74018223tun__ic
untrim8310683_untrim
valeric1238303valeric
vanadic1336743vanadic
vatic10316423va_t_ic
vitric112510113_vitric
wastrie101210303wastrie
xanthin1747043xanthin
yantra9449623yantr_a
yantras10259003yantras
yttric1145433_yttric

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 Filter1786911340270.470380193.6
2DLD Change Limit1340271606.90619407.3
3Display Results1601600.0632539.7
 (SQL Overall)1786911607.43924020.8
 
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.