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

117 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
xanthins184694(None) 
xanthans1845691xanthans
xantheins1944811xantheins
xanthin1747041xanthin_
xanthine1847251xanthine
xanthines1966721xanthines
xanthan1736012xanthan_
xanthein1845012xanthein_
xanthene1855552xanthene
xanthenes1956352xanthenes
xanthic1945862xanthi_c
xanthone1847112xanthone
xanthones1957022xanthones
xanthous1846642xanthous
acanthine1474833acanthine
actins86321103_act_ins
anilins7416793_anilins
anteing8312813_anteing
anthems12309423_anthems
anthers103715203_anthers
anthill1048203_anthill
anthills1146533_anthills
antics84621453_ant_ics
anting75827023_ant_ing
antings85015583_ant_ings
antis55033313_ant_i_s
antlions839193_antlions
anything1534993_anything
anythings1642593_anythings
arshins10312573_arshins
attains7310983_attains
banshies131110663banshies
banties94324763bant_ies
bantling112612003bantling
bantlings12216603bantlings
bathing134816243ba_thing
benthons1337973benthons
canakins142010463canakins
canikins14219163canikins
canteens1038573canteens
canthi11310973canthi__
canthitis1445273canthitis
canthus1248713canth_us
cantina93417253cant_ina
cantinas102713783cant_inas
canting104725903cant_ing
cantons95221203cant_ons
cantrips12318933cantrips
captains121810573captains
catkins133012563ca_tkins
catlins93818843ca_tlins
contains10316533contains
dauphins1444523dauphins
dentins83419223dent_ins
earthing12310333earthing
exanthems2142763exanthems
faithing1537153faithing
fantails1139693fantails
farthing1538073farthing
farthings1635233farthings
fenthions1544233fenthions
gantline9410903gantline
gantlines1039333gantlines
gantries91413793gantries
gastrins9310123gastrins
gnathions1343303gnathions
hanting114124483hant_ing
hatpins123410643ha_tpins
lanolins8310533lanolins
lanterns838303lanterns
lanthorns1246013lanthorns
lashins103915153la_shins
lathing114315693la_thing
lathings12469853la_things
lathis95516173la_thi_s
lattins74115483la_ttins
maintains1167103maintains
manakins14209763manakins
manikins14189723manikins
mantids103113623mant_ids
mantis83926033mant_i_s
mantling112012613mantling
mantlings12207233mantlings
martins93322063mart_ins
matins84527783ma_t_ins
mattins93316143ma_ttins
muntins92715133munt_ins
naething1236073naething
naethings1343873naethings
nandins8312003nan_dins
nankins1159053nan_kins
pantheons1446513pantheons
panthers13510783panthers
panties94230933pant_ies
panting104025423pant_ing
pantries101817393pantries
patins87528783pa_t_ins
plantains1147493plantains
ranching141712043ranching
ranting84025413rant_ing
ratlins73615583ra_tlins
sandhis1139993sandhi_s
santims9312603sant_ims
santirs7312963sant_irs
santonins948453santonins
satins64930483sa_t_ins
tannins72813223tan_nins
thins85826333___thins
unthink1457003_unthink
unthinks1574503_unthinks
wanting114220173want_ing
wantons103713013want_ons
withins133511693_withins
xanthate1845713xanthate
xanthates1945653xanthates
xanthoma2043973xanthoma
xanthomas2143643xanthomas

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 Filter1786911461620.423422437.4
2DLD Change Limit1461621177.25020160.3
3Display Results1171170.0462543.5
 (SQL Overall)1786911177.71923149.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.