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 “byzants” 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
byzants215322(None) 
bezants1877341bezants
byzant2096811byzant_
bezant17814542bezant_
bezzants1843642bezzants
brants85723052b_rants
tyrants1037452tyrants
alants67722023_alants
ants47243473___ants
azans146516883_azan_s
bahts105617803b__ahts
baits76630583b__aits
bananas93312223bananas
bands85233423b__ands
banes74945583b__anes
bangs85627773b__angs
banks115527903b__anks
banns75321233b__anns
bans66555133b__an_s
banty106624003b__anty
basalts9358963basalts
basts75936933b__asts
bats66962333b__a_ts
batts76727563b__atts
bazaars18275883bazaars
bazars174613113baza_rs
beanos85516513b_eanos
beans75734693b_ean_s
beasts84519723b_easts
beats76042243b_ea_ts
beauts86015283b_eauts
bents76033693b__ents
bepaints1235113bepaints
bezzant1746893bezzant_
bhangs12449663b_hangs
bints76130183b__ints
bionts8612393b_ionts
bizones1837823bizones
blanks124112893b_lanks
blasts85116773b_lasts
blats75132503b_la_ts
bleats85518613blea_ts
bloats85215763bloa_ts
blunts84512893b_lunts
boarts84716873b_oarts
boasts85017923b_oasts
boats75635153b_oa_ts
bogans95714813bogan_s
bogarts1047743bogarts
boranes93720403boranes
bracts105617773b_racts
brands95118943b_rands
branks124817383b_ranks
brans75437433b_ran_s
brant74742173b_rant_
brats75336013b_ra_ts
breasts939703breasts
brents84717273b_rents
brunts85215453b_runts
bunts75729803b__unts
burans85019303buran_s
butanes9312743butanes
bwanas1157443b_wanas
bygones1335913bygones
bylaws14415833byla_ws
bylines1239243bylines
bynames14256243bynames
bypass1345043bypa_ss
bypast13117373bypast_
bypath1645353bypa_th
bypaths1743193bypaths
bytalks1632713bytalks
byways1734673bywa_ys
byzantine2342163byzantine
cants77036943__cants
chants115020393_chants
cyans105714813cy_an_s
decants103514443decants
dopants1038433dopants
dynasts1155103dynasts
eluants737583eluants
errants7410623errants
gelants82611443gelants
giants74713503_giants
grants73722473_grants
hants86335403__hants
hazans183411653hazan_s
hydrants1585793hydrants
incants92012803incants
infants102210773infants
jurants14379213jurants
kyats125012443ky_a_ts
levants1037723levants
mutants938583mutants
octants9128733octants
pants76536923__pants
pedants10310113pedants
plants84921803_plants
pyrans11411063pyran_s
quants153614143_quants
rants55935343__rants
recants93217093recants
savants1038653savants
scants85219723_scants
secants93413893secants
slants64819083_slants
sonants7511233sonants
tenants7311013tenants
truants738153truants
tyrant9315333tyrant_
wants87932213__wants
xylans1635883xylan_s
yangs95618693_y_angs
yanks125316573_y_anks
yeans86624883_yean_s
yeasts96413053_yeasts
yuans84613323_yuan_s

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.1731032896.0
2DLD Change Limit1340271176.87319500.5
3Display Results1171170.0462543.5
 (SQL Overall)1786911177.09225196.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.