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

131 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
kyte11701777(None) 
byte96521811byte
hyte109018941hyte
kite85338251kite
kye107327281ky_e
kytes125012911kytes
kythe15509671kythe
wyte106018641wyte
ante46538902ante
ate37059242_ate
aye67151762ay_e
bate66552422bate
bite66547012bite
bute66739672bute
bye86134592by_e
byre95023852byre
bytes105217492bytes
cate66254602cate
cete64934782cete
cite65640352cite
cote66648732cote
cute66440452cute
cyme119420372cyme
date56443322date
dite55547562dite
dote55442882dote
dye75334842dy_e
dyke126418182dyke
dyne85320932dyne
eye65539772ey_e
eyne76322462eyne
eyre75525252eyre
fate75444282fate
fete75734922fete
flyte115713942flyte
fyce126316832fyce
fyke145915292fyke
fytte1138582fytte
gate55746572gate
gite55438622gite
gybe105916242gybe
gyre84722762gyre
gyve116215082gyve
hate78450172hate
hype125519812hype
jete115927252jete
jute115327892jute
kae76744552k_ae
kale86533762kale
kame105728252kame
kane85133982kane
kat77468302kat_
kata85626042kata
kats85944342kats
keet85347352keet
kente95821072kente
keto86223462keto
khet116328632khet
kibe106523462kibe
kike76524802kike
kine85643442kine
kit78559892kit_
kited105120102kited
kiter95523222kiter
kites95432552kites
kith115826372kith
kithe125917462kithe
kits86441782kits
knee85323612knee
kore85834172kore
koto86323482koto
kue76631872k_ue
kune85424582kune
kyak105213642kyak
kyar116916852kyar
kyat116025532kyat
kyats125012442kyats
kyes115124942kyes
kyrie123712902kyrie
kythed17407312kythed
kythes16499132kythes
late47560482late
lite47054552lite
lute46341012lute
lye66533412ly_e
lyre75623792lyre
lyse76320592lyse
mate65154222mate
mete64438132mete
mite66249422mite
mote67048082mote
mute65136872mute
myth126715432myth
nite45943592nite
note46239962note
pate65350462pate
pye86432502py_e
pyre94925552pyre
rate45458762rate
rete44944132rete
rite45849462rite
rote46249022rote
rye66032542ry_e
ryke115616402ryke
sate45556102sate
site47052422site
skate94721552skate
skite95120062skite
stye76218972stye
syce95820282syce
syke115420562syke
syne75725762syne
tate44748602tate
tote46643672tote
tye65837442ty_e
tyee75131422tyee
tyke115720502tyke
tyne76325052tyne
type96223742type
tyre75428252tyre
tythe115210452tythe
ute35335882_ute
vote74728622vote
wite75443282wite
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.266671770.7
2DLD Change Limit298721310.78038297.4
3Display Results1311310.0304366.7
 (SQL Overall)1786911311.076166069.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.