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

160 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
byzant209681(None) 
bezant17814541bezant
byzants2153221byzants
bezants1877342bezants
bezzant1746892bezzant
brant74742172b_rant
bypast13117372bypast
tyrant9315332tyrant
abeyant1248083abeyant
alant55742293_alant
ant37270783___ant
arrant6623253arrant
askant10412713askant
aslant6317753aslant
avant86224663_avant
azan136521783_azan_
azans146516883_azans
baht96740013b__aht
bait66556003b__ait
ban58366833b__an_
banana83213413banana
band76740903b__and
bane65250423b__ane
bang74836993b__ang
bani65334953b__ani
bank105835743b__ank
bans66555133b__ans
banty106624003b__anty
basalt83519583basalt
bast66362413b__ast
bat510988953b__a_t
batt65053873b__att
bayman133712703bayman_
bazaar17306403bazaar
bazar163816003baza_r
bazars174613113bazars
bean66443863b_ean_
beano75421553b_eano
beans75734693b_eans
beast76338643b_east
beat66168303b_ea_t
beaut75135213b_eaut
began86319573began_
begat86629723bega_t
bent67759913b__ent
bepaint11312183bepaint
bezazz1543983bezazz
bezzants1843643bezzants
bhang115512923b_hang
bint67355043b__int
biont7727163b_iont
bizone1738603bizone
bland85320453b_land
blank115418553b_lank
blast76532573b_last
blat66550953b_la_t
blatant9310673blatant
bleat75737003blea_t
blent76230953b_lent
bloat75229923bloa_t
blunt75525023b_lunt
boart78835933b_oart
boast75935703b_oast
boat66360313b_oa_t
bogan87519003bogan_
bogans95714813bogans
bogart9617193bogart
borane84620213borane
botany1139263botany
bract96332723b_ract
bran65740383b_ran_
brand85124493b_rand
brank115222283b_rank
brans75437433b_rans
brants85723053b_rants
brat66055543b_ra_t
breast8319633breast
brent75734133b_rent
brisant9312683brisant
brunt75728753b_runt
bunt65850853b__unt
buoyant1246263buoyant
buran75225303buran_
burans85019303burans
burnt75230323b_urnt
butane8313653butane
bwana10310243b_wana
bygone1256173bygone
bylaw13408603byla_w
bylaws14415833bylaws
byline11311643byline
byname13256363byname
bypass1345043bypass
bypath1645353bypath
bytalk1533473bytalk
byway1647533bywa_y
byways1734673byways
byzantine2342163byzantine
cant66362023__cant
chant105932693_chant
cyan96419623cy_an_
cyano105512493cy_ano
cyans105714813cy_ans
decant93524223decant
dopant9316133dopant
dynast1088223dynast
eluant6315093eluant
errant6618733errant
extant132714753extant
gelant72821673gelant
giant65430593_giant
grant64840023_grant
hant75461583__hant
hazan173813613hazan_
hazans183411653hazans
hydrant1489053hydrant
incant82418503incant
infant92315133infant
jurant134216553jurant
kyat116025523ky_a_t
leant56737783_leant
levant9314493levant
lyart85121883ly_art
meant76537203_meant
mutant8317693mutant
natant6318733natant
nutant6316383nutant
octant81216553octant
pant66061253__pant
pedant9319493pedant
plant75437113_plant
pliant83918823pliant
pyran10514473pyran_
pyrans11411063pyrans
quant143624813_quant
rant45864673__rant
recant83228683recant
riant55833153_riant
savant9416043savant
scant79735073_scant
secant84023293secant
sejant133114483sejant
slant55238703_slant
sonant6621953sonant
tenant6322473tenant
truant6315783truant
tyrants1037453tyrants
vacant11415133vacant
volant9316323volant
want76156163__want
xylan1537463xylan_
xylans1635883xylans
yang85626063_y_ang
yank115423663_y_ank
yean75834583_yean_
yeans86624883_yeans
yeast85327943_yeast
yuan76120013_yuan_
yuans84613323_yuans
zany167316983__zany

Search took 10 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 Filter1786911127160.1401276364.3
2DLD Change Limit1127161609.06312436.9
3Display Results1601600.0463478.3
 (SQL Overall)1786911609.24919320.0
 
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.