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

186 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
tyees8601945(None) 
tees45353581t_ees
trees55835761trees
tyee75131421tyee_
tyers86220051tyers
tyes76433371ty_es
tykes125817061tykes
tynes85920301tynes
types105721061types
tyres84725231tyres
akees96119242akees
ayes76543512ay_es
bees65453382_bees
brees75632552brees
byes95230532by_es
byres104421382byres
bytes105217492bytes
cees65941592_cees
cyeses11510122cyeses
cymes1210118922cymes
dees56356632_dees
drees65628522drees
dyers96617132dyers
dyes85331892dy_es
dykes135215572dykes
dynes95917582dynes
epees75219832epees
etwees9348792etwees
eyers86521332eyers
eyes75837882ey_es
eyres84921772eyres
fees76450602_fees
flees85828752flees
frees86131392frees
fyces139813642fyces
fykes156312692fykes
gees55647882_gees
ghees95215552ghees
glees65027592glees
grees65132472grees
gybes115012722gybes
gyres94820322gyres
gyves125711552gyves
hypes135818672hypes
jees115938542_jees
knees95114872knees
kyes115124932ky_es
kytes125012912kytes
lees45455882_lees
lycees11428862lycees
lyes75530832ly_es
lyres85019962lyres
lyses84518252lyses
ogees65119142ogees
oyers87620882oyers
oyes74940132oy_es
oyezes1835052oyezes
payees114812902payees
pees65257372_pees
prees75937172prees
pyes95528992py_es
pyres105523882pyres
pyxes175911402pyxes
rees45364192_rees
ryes75529352ry_es
rykes125513032rykes
sees45361052_sees
skees95023122skees
styes86316522sty_es
styles94418652styles
sycees11409652sycees
syces106416462syces
sykes124816862sykes
tabes76033922tabes
taces76237802taces
taels56822072taels
tajes124920692tajes
takes94437792takes
tales55451372tales
tames75242012tames
tapes75838602tapes
tares57456562tares
tates55444982tates
taxes124730822taxes
teas45851492t_eas
teds54932572t_eds
tee38366872t_ee_
teed55439262t_eed
teel46335802t_eel
teels55726372teels
teem66132602t_eem
teems76019782teems
teen45938202t_een
teens56227482teens
tegs56031492t_egs
teles54536002teles
tels46841692t_els
tens45647412t_ens
tepees84215242tepees
tets45847452t_ets
tews76431642t_ews
thebes115914492thebes
thee78039062thee_
themes115319252themes
thens85921832thens
theres96525472theres
these86519012these
theses96517972theses
thews117416192thews
threes97117322threes
thymes144810742thymes
tides64830152tides
tiers55526522tiers
ties45248312t_ies
tikes95628902tikes
tiles55542102tiles
times75630822times
tines54848422tines
tires55437492tires
tmeses85712242tmeses
toeas55726422toeas
toes46956442t_oes
tokes95234972tokes
toles55147132toles
tomes76037382tomes
tones56048662tones
topees85519702topees
topes76941762topes
tores55352672tores
totes55139682totes
toyers95516332toyers
tree47745812tree_
treed65626732treed
treen55622752treen
treens65317872treens
treks96016852treks
tres46542902t_res
tress55423162tress
trets55928022trets
trews86118892trews
treys85018212treys
tries55742812tries
trues54925322trues
tubes74826452tubes
tules54532792tules
tunes55332192tunes
tutees6514552tutees
tuxes124316042tuxes
tuyeres10417792tuyeres
tuyers94612562tuyers
twaes86513662twaes
twee76827082twee_
tweed94915092tweed
tweeds10498432tweeds
tween84413742tween
tweens9489842tweens
tweet84823982tweet
tweets94210102tweets
twyers12497412twyers
tye65837442ty_e_
tyer75323392ty_er
tyke115720502tyke_
tyne76325052tyne_
tyned95915012tyned
type96223742type_
typed115815452typed
typey135511882typey
typos106015812typos
typps12549302typps
tyre75428252tyre_
tyred95816432tyred
tyros85118592tyros
tythes12419702tythes
vees75439432_vees
wees76249122_wees
wyes105727502wy_es
wyles114615322wyles
wytes114113432wytes
yeas78638422_yeas
yens75832262_yens
yeps95924402_yeps
yes66250612_y_es
yeses85119322_yeses
yews105323962_yews
zees136331892_zees
zymes1924712942zymes

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 Filter178691538000.0931921408.6
2DLD Change Limit538001861.73630990.8
3Display Results1861860.0464043.5
 (SQL Overall)1786911861.87595301.9
 
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.