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

82 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
xanthans184569(None) 
xanthan1736011xanthan_
xanthins1846941xanthins
xanthate1845712xanthate
xanthates1945652xanthates
xantheins1944812xantheins
xanthene1855552xanthene
xanthenes1956352xanthenes
xanthin1747042xanthin_
xanthine1847252xanthine
xanthines1966722xanthines
xanthone1847112xanthone
xanthones1957022xanthones
xanthous1846642xanthous
afghans1443573_afghans
antas55432033_ant_a_s
anthems12309423_anthems
anthers103715203_anthers
antiars7314623_antiars
anurans73810553_anurans
atmans84413963_a_tmans
banians9312033ban_ians
bantams1149063bant_ams
banyans1237913ban_yans
barchans1588683barchans
benthons1337973benthons
caftans12179443caft_ans
cancans11311873can_cans
canchas143212403cancha_s
cantals93919573cant_als
canteens1038573canteens
canthal12410053cantha_l
cantharis1447183cantharis
canthus1248713canth_us
cantinas102713773cantinas
cantons95221203cant_ons
cantraps12319113cantraps
captans111612053capt_ans
darshans1286543darshans
exanthems2142763exanthems
gentians937563gentians
hanumans1344953hanumans
kaftans14185353kaft_ans
kanbans1337723kan_bans
kantars11310033kant_ars
langshans1344283langshans
lantana739603lant_ana
lantanas838263lant_anas
lanterns838303lanterns
lanthanon1252623lanthanon
lanthanons1352553lanthanons
lanthanum1452533lanthanum
lanthanums1551853lanthanums
lanthorns1246013lanthorns
malthas1237913maltha_s
mannans93611523man_nans
mantas85725363mant_a_s
manteaus1036383manteaus
mantrams12288963mantrams
mantraps12298063mantraps
mantras93815863mantra_s
mantuas93410993mantua_s
martians103111613martians
pantheons1446513pantheons
panthers13510783panthers
partans94418283part_ans
randans8313213ran_dans
ratans63819373ra_t_ans
rattans73411953ra_ttans
saltpans1034813saltpans
suntans72111733sunt_ans
tantras73112093tantra_s
tartans72615823tart_ans
urethans1145243urethans
wangans1149503wan_gans
wanigans1244743wanigans
wantons103713013want_ons
xanthein1845013xanthein
xanthic1945863xanth_ic
xanthoma2043973xanthoma
xanthomas2143643xanthomas
yantras10259003yantra_s

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 Filter1786911461620.406440125.6
2DLD Change Limit146162826.37322934.6
3Display Results82820.0332484.8
 (SQL Overall)178691826.81226231.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.