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

91 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
xanthic194586(None) 
xanthin1747041xanthin
antic75728862_ant_ic
benthic1437472benthic
canthi11310972canthi_
cantic103920542cant_ic
gnathic1344842gnathic
mantic104120902mant_ic
mantric11311342mantric
tantric939582tantric
xanthan1736012xanthan
xanthein1845012xanthein
xanthine1847252xanthine
xanthins1846942xanthins
acanthi1244663acanthi_
ailanthic1443373ailanthic
anemic102713693_anemic
anisic8313793_anisic
anodic92813133_anodic
anomic102516303_anomic
anorthic1346973_anorthic
anoxic152610673_anoxic
anthem113410343_anthem
anthemic15410323_anthemic
anther93715063_anther
anthill1048203_anthill
anthoid11313313_anthoid
anti45536363_ant_i_
antick124814583_ant_ick
antics84621453_ant_ics
antis55033313_ant_is
anuric8812103_anuric
attic75618353_a_ttic
bacchic1545813bacchic
banshie12129543banshie
canonic11312933canonic
canopic1338803canopic
canthal12410053canthal
canthus1248713canthus
cantrip112910043cantrip
centric11312403centric
enatic8317563enat_ic
erethic1257723erethic
ethic101511223__ethic
exanthem2043113exanthem
fanatic12610693fanatic
fanfic1436313fan_fic
fantail10310233fantail
frantic12310363frant_ic
gastric1038633gastric
gothic1237793_gothic
haptic13511893hapt_ic
iatric8312163ia_tric
lactic10713493lact_ic
lathi85417203la_thi_
lathis95516173la_this
lentic83515743lent_ic
lithic1139493_lithic
manic94629443man__ic
mantid93820383mant_id
mantis83926033mant_is
mastic103119173mast_ic
mythic1637273_mythic
nastic82915973nast_ic
ontic74418573_ont_ic
ornithic1343623ornithic
panic93923903pan__ic
panther12611443panther
pantie84326473pant_ie
quantic18279063quant_ic
sandhi1038193sandhi_
sandhis1139993sandhis
santalic1048893santalic
santir6315253sant_ir
sapphic1644553sapphic
spathic1437543spathic
tactic10612753tact_ic
tannic82811473tan_nic
tantalic1048053tantalic
unchic1338643_unchic
vanadic1336743vanadic
vatic10316423va_t_ic
xanthans1845693xanthans
xanthate1845713xanthate
xantheins1944813xantheins
xanthene1855553xanthene
xanthines1966723xanthines
xanthoma2043973xanthoma
xanthone1847113xanthone
xanthous1846643xanthous
xenic144114643xen__ic

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.406440125.6
2DLD Change Limit134027916.54620474.6
3Display Results91910.0461978.3
 (SQL Overall)178691916.99825534.6
 
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.