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

162 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
hyte10901894(None) 
byte96521811byte
hate78450171hate
hype125519811hype
kyte117017761kyte
wyte106018641wyte
ante46538902ante
ate37059242_ate
aye67151762ay_e
bate66552422bate
bite66547002bite
bute66739672bute
bye86134592by_e
byre95023852byre
bytes105217492bytes
cate66254602cate
cete64934782cete
chute104316462chute
chyle134913482chyle
chyme156512502chyme
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
hade85440192hade
hae67364002h_ae
haet75659502haet
hake115637842hake
hale76052832hale
hame97043132hame
hare76255732hare
haste85927862haste
hat67289962hat_
hated95734022hated
hater85034752hater
hates86742572hates
hath105933912hath
hats76858252hats
haute89521612haute
have106137072have
haze164833392haze
he58151952h__e
hebe96424702hebe
heme95034412heme
here76447102here
het67674312het_
heth107028022heth
hets75547202hets
hide85134642hide
hie67652702h_ie
hike116830392hike
hire75538962hire
hit66569192hit_
hits75545132hits
hive106029672hive
hoe67562722h_oe
hoke115935932hoke
hole77553392hole
home98042442home
hone77549322hone
hope96639672hope
hose76547242hose
hot67776062hot_
hotel85520752hotel
hots78349332hots
hove107132222hove
howe106734102howe
hoyle11314412hoyle
hue66642302h_ue
huge86321652huge
hut66457292hut_
huts76737442huts
hyla106716512hyla
hymen13311042hymen
hymn12311312hymn
hyp117822462hy_p
hyped145313332hyped
hyper135213902hyper
hypes135818672hypes
hypo127516352hypo
hyps125418412hyps
jete115927252jete
jute115327892jute
kite85338242kite
kye107327272ky_e
kytes125012912kytes
kythe15509672kythe
late47560482late
lite47054542lite
lute46341012lute
lye66533412ly_e
lyre75623792lyre
lyse76320592lyse
mate65154222mate
mete64438132mete
mite66249412mite
mote67048082mote
mute65136872mute
myth126715432myth
nite45943582nite
note46239962note
pate65350462pate
phyle134111152phyle
pye86432502py_e
pyre94925552pyre
rate45458762rate
rete44944132rete
rhyme13479552rhyme
rhyta1135082rhyta
rite45849452rite
rote46249022rote
rye66032542ry_e
ryke115616402ryke
sate45556102sate
shote85526102shote
shute84520352shute
site47052412site
stye76218972stye
syce95820282syce
syke115420562syke
syne75725762syne
tate44748602tate
thyme134612472thyme
tote46643672tote
tye65837442ty_e
tyee75131422tyee
tyke115720502tyke
tyne76325052tyne
type96223742type
tyre75428252tyre
tythe115210452tythe
ute35335882_ute
vote74728622vote
white114920302white
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.280638182.1
2DLD Change Limit298721620.73340753.1
3Display Results1621620.0463521.7
 (SQL Overall)1786911621.059168735.6
 
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.