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 “byte” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

168 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
byte9652181(None) 
bate66552421bate
bite66547001bite
bute66739671bute
bye86134591by_e
byre95023851byre
bytes105217491bytes
hyte109018941hyte
kyte117017761kyte
wyte106018641wyte
abate76627842abate
abye97921002aby_e
ante46538902ante
ate37059242_ate
aye67151762ay_e
babe86835822babe
bade75140882bade
bake105637512bake
bale66353842bale
bane65250432bane
bare65460522bare
baryte115312882baryte
base64847022base
baste74829982baste
bat510988952bat_
bated85935532bated
bates75846342bates
bath95940082bath
bathe105822882bathe
bats66962332bats
batt65053872batt
be47948942b__e
bee56262402b_ee
beet66457542beet
bene66439492bene
bet58376672bet_
beta66234132beta
betel74419902betel
beth96629232beth
bets67051442bets
bice86235562bice
bide76041482bide
bike106532602bike
bile66147182bile
bine66650862bine
bise66437102bise
bit57070902bit_
biter75030032biter
bites75641172bites
bits66148162bits
bitt65545812bitt
bize155926292bize
blae66134642blae
blate75933782blate
blet66247672blet
blite76225352blite
blue65328462blue
blype12429672blype
bode75838752bode
boite74426322boite
bole66448692bole
bone65949322bone
bore66051332bore
bot59680402bot_
bota66236502bota
botel75121862botel
both96533432both
bots66453952bots
bott66548572bott
brae65639112brae
bree67241262bree
brie65837902brie
brute75321782brute
but55963022but_
buteo75419892buteo
butes714535872butes
butle75023102butle
buts67247692buts
butt65143742butt
butte74924292butte
by77529232by__
byes95230532byes
byres104421382byres
byrl95716012byrl
bys85229462by_s
cate66254602cate
cete64934782cete
cite65640342cite
cote66648732cote
cute66440452cute
cyme119420372cyme
date56443322date
dite55547552dite
dote55442882dote
dye75334842dy_e
dyke126418182dyke
dyne85320932dyne
eye65539772ey_e
eyne76322462eyne
eyre75525252eyre
fate75444282fate
fete75734922fete
flyte115713942flyte
fyce126316832fyce
fyke145915292fyke
fytte1138582fytte
gate55746572gate
gite55438612gite
gybe105916242gybe
gyre84722762gyre
gyve116215082gyve
hate78450172hate
hype125519812hype
jete115927252jete
jute115327892jute
kite85338232kite
kye107327272ky_e
kytes125012912kytes
kythe15509672kythe
late47560482late
lite47054542lite
lute46341012lute
lye66533412ly_e
lyre75623792lyre
lyse76320592lyse
mate65154222mate
mete64438132mete
mite66249412mite
mote67048082mote
mute65136872mute
myth126715432myth
nite45943582nite
note46239962note
pate65350462pate
pye86432502py_e
pyre94925552pyre
qubyte2034242qubyte
rate45458762rate
rete44944132rete
rite45849452rite
rote46249022rote
rye66032542ry_e
ryke115616402ryke
sate45556102sate
site47052412site
stye76218972stye
syce95820282syce
syke115420562syke
syne75725762syne
tate44748602tate
tote46643672tote
tye65837442ty_e
tyee75131422tyee
tyke115720502tyke
tyne76325052tyne
type96223742type
tyre75428252tyre
tythe115210452tythe
ute35335882_ute
vote74728622vote
wite75443272wite
wye96331972wy_e
wyle105519382wyle
wyted12529472wyted
wytes114113432wytes
ye57650062_y_e
yet66960692_yet
zyme1819114942zyme

Search took 2 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 Filter178691298720.1401276364.3
2DLD Change Limit298721681.56319112.0
3Display Results1681680.0305600.0
 (SQL Overall)1786911681.733103110.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.