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

206 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
tyee7513142(None) 
tee38366871t_ee
thee78039061thee
tree47745811tree
twee76827081twee
tye65837441ty_e
tyees86019451tyees
tyer75323391tyer
tyes76433371tyes
tyke115720501tyke
tyne76325051tyne
type96223741type
tyre75428251tyre
agee56241492agee
ajee115928232ajee
akee85936812akee
alee46652322alee
awee76336642awee
aye67151762ay_e
ayes76543512ayes
bee56262402_bee
bree67241262bree
bye86134592by_e
byes95230532byes
byre95023852byre
byte96521812byte
cee55952702_cee
cyme119420372cyme
dee47665822_dee
dree56638322dree
dye75334842dy_e
dyed96720762dyed
dyer85522112dyer
dyes85331892dyes
dyke126418182dyke
dyne85320932dyne
epee64628502epee
etwee84115332etwee
eye65539772ey_e
eyed86623232eyed
eyen76223662eyen
eyer76127282eyer
eyes75837882eyes
eyne76322462eyne
eyre75525252eyre
fee66862012_fee
flee76238792flee
free75940182free
fyce126316832fyce
fyke145915292fyke
gee45359202_gee
ghee85726112ghee
glee55239062glee
gree56641562gree
gybe105916242gybe
gyre84722762gyre
gyve116215082gyve
hype125519812hype
hyte109018942hyte
jee106648642_jee
knee85323602knee
kye107327272ky_e
kyes115124932kyes
kyte117017762kyte
lee36068142_lee
lycee104716742lycee
lye66533412ly_e
lyes75530832lyes
lyre75623792lyre
lyse76320592lyse
nee36657782_nee
ogee57629882ogee
oyer75927652oyer
oyes74940132oyes
oyez166020352oyez
payee105524722payee
pee56066512_pee
pree67044732pree
pye86432502py_e
pyes95528992pyes
pyre94925552pyre
ree37974072_ree
rye66032542ry_e
ryes75529352ryes
ryke115616402ryke
see35772262_see
skee85431472skee
stye76218972sty_e
styed95815482styed
styes86316522styes
style85519362style
syce95820282syce
sycee105018622sycee
syke115420562syke
syne75725762syne
tace65342512tace
tae38267052t_ae
tael46030712tael
take84739262take
tale46154162tale
tame66343662tame
tape64538142tape
tare45957622tare
tate44748602tate
tea37353322t_ea
ted46446562t_ed
teed55439262teed
teel46335802teel
teem66132602teem
teen45938202teen
tees45353582tees
teg45741622t_eg
tel35647902t_el
tele45040872tele
ten35856112t_en
tepee74724212tepee
tet39274992t_et
tew66640152t_ew
thae76825562thae
the67436052t_he
thebe107515432thebe
them97427042them
theme105921732theme
then78429692then
there87527392there
these86519012these
thew108226232thew
they107223752they
three87526912three
thyme134612472thyme
tide55237372tide
tie36557532t_ie
tied55535212tied
tier44936142tier
ties45248312ties
tike85534482tike
tile45451442tile
time66235012time
tine45855132tine
tire46143352tire
toe310166852t_oe
toea46732332toea
toed56137042toed
toes46956442toes
toke86738492toke
tole46052902tole
tome67543192tome
tone46953742tone
tope65946382tope
topee76029952topee
tore47359322tore
tote46643672tote
toyed96019802toyed
toyer84521552toyer
treed65626732treed
treen55622752treen
trees55835762trees
tref77030992tref
trek86222312trek
tres46542902tres
tret46653532tret
trey77228792trey
true46725852true
tube65828662tube
tule45735872tule
tune45635862tune
tutee5423522tutee
tuyer85414292tuyer
tuyere9408612tuyere
twae74719572twae
tweed94915092tweed
tween84413742tween
tweet84823982tweet
twyer11558522twyer
tyers86220052tyers
tyin76424002tyin
tykes125817062tykes
tyned95915012tyned
tynes85920302tynes
typed115815452typed
types105721062types
typey135511882typey
typo95418122typo
typp115812782typp
typy126013042typy
tyred95816432tyred
tyres84725232tyres
tyro76622362tyro
tythe115210452tythe
vee65750182_vee
wee66760812_wee
whee105429592whee
wye96331972wy_e
wyes105727502wyes
wyle105519382wyle
wyte106018642wyte
ye57650062_y_e
yea66445752_yea
yeh97135772_yeh
yen66847382_yen
yep86638962_yep
yes66250612_yes
yet66960692_yet
yew96436292_yew
zee126143232_zee
zyme1819114942zyme

Search took 1 second 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.0632836365.1
2DLD Change Limit298722060.86034734.9
3Display Results2062060.0464478.3
 (SQL Overall)1786912060.969184407.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.