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

111 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
xanthin174704(None) 
xanthan1736011xanthan
xanthein1845011xanthein
xanthic1945861xanthic
xanthine1847251xanthine
xanthins1846941xanthins
canthi11310972canthi_
xanthans1845692xanthans
xantheins1944812xantheins
xanthene1855552xanthene
xanthines1966722xanthines
xanthone1847112xanthone
acanthi1244663acanthi_
acanthine1474833acanthine
actin74922553_act_in
anilin6417793_anilin
anteing8312813_anteing
anthem113410343_anthem
anther93715063_anther
anthill1048203_anthill
anthoid11313313_anthoid
anti45536363_ant_i_
antic75728863_ant_ic
anting75827023_ant_ing
antis55033313_ant_is
antlion7310293_antlion
anything1534993_anything
arshin9312173_arshin
attain6311753_attain
banshie12129543banshie
bantling112612003bantling
bathing134816243ba_thing
benthic1437473benthic
benthon1237693benthon
canakin131810833canakin
canikin13189753canikin
canteen9411083canteen
canthal12410053canthal
canthus1248713canthus
cantic103920543cant_ic
cantina93417253cant_ina
canting104725903cant_ing
canton85722993cant_on
cantrip112910043cantrip
captain112111063captain
catkin123512383ca_tkin
catlin83819083ca_tlin
contain9315833contain
dauphin1344383dauphin
dentin73919573dent_in
earthen1039253earthen
earthing12310323earthing
exanthem2043113exanthem
faithing1537153faithing
fantail10310233fantail
farthing1538073farthing
fenthion1444613fenthion
gantline9410903gantline
gastrin839833gastrin
gnathic1344843gnathic
gnathion1243443gnathion
hanting114124483hant_ing
hatpin112610613ha_tpin
lanolin7310643lanolin
lantern7310013lantern
lanthorn1147193lanthorn
lathi85417203la_thi_
lathing114315693la_thing
lathis95516173la_this
lattin64316223la_ttin
maintain1077723maintain
manakin131810643manakin
manikin132110243manikin
mantic104120903mant_ic
mantid93820383mant_id
mantis83926033mant_is
mantling112012613mantling
mantric11311343mantric
martin84122523mart_in
matin75132853ma_t_in
mattin84416633ma_ttin
muntin82915183munt_in
naething1236073naething
nandin7313033nan_din
nankin1039673nan_kin
pantheon1346313pantheon
panther12611443panther
pantie84326473pant_ie
panting104025423pant_ing
patin76832853pa_t_in
plantain1047903plantain
ranching141712043ranching
ranting84025413rant_ing
ratlin64116523ra_tlin
sandhi1038193sandhi_
sandhis1139993sandhis
santir6315253sant_ir
santonin849703santonin
satin55935223sa_t_in
tannin62613923tan_nin
tantric939583tantric
thin76732393___thin
unthink1457003_unthink
wanting114220173want_ing
wanton94413813want_on
within123611383_within
xanthate1845713xanthate
xanthenes1956353xanthenes
xanthoma2043973xanthoma
xanthones1957023xanthones
xanthous1846643xanthous

Search took 7 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.1401276364.3
2DLD Change Limit1340271116.65620136.3
3Display Results1111110.0462413.0
 (SQL Overall)1786911116.84226116.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.