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

142 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
tyred9581643(None) 
gyred105114091gyred
tared69340051tared
tired65228901tired
tyned95915011tyned
typed115815451typed
tyre75428251tyre_
tyres84725231tyres
acred87126352acred
aired66032922aired
bared85144482bared
bored85034302bored
bred75130972_bred
byre95023852byre_
byres104421382byres
byrled12437172byrled
cared86050092cared
cered85227442cered
cored85044222cored
cred76530882_cred
cured85932132cured
dared75935012dared
dured75025402dured
dyed96720762dy_ed
dyked145310952dyked
eared65139502eared
erred65915672erred
eyed86623232ey_ed
eyre75525252eyre_
eyres84921772eyres
fared95842342fared
fired94829742fired
gored75227082gored
gybed125811022gybed
gyre84722762gyre_
gyres94820322gyres
gyved13568742gyved
hared95742182hared
hired95226262hired
hyped145313332hyped
ired55131872_ired
lured65427492lured
lyre75623792lyre_
lyres85019962lyres
lysed95011562lysed
mired85729222mired
mured85726702mured
oared65030652oared
pared86946762pared
pored85234512pored
pyre94925552pyre_
pyres105523882pyres
pyrex175211212pyrex
rared65738322rared
red46755802__red
ryked13669512ryked
sered65737292sered
shred98125612shred
sired66134282sired
sored66141782sored
stared75429872stared
stored75524212stored
styed95815482sty_ed
styled105613102styled
syren85216742syren
tamed85528512tamed
taped85327422taped
tare45957622tare_
tares57456562tares
tarred74720282tarred
tarted74923372tarted
tawed95926192tawed
taxed135620292taxed
teared75722152teared
ted46446562t__ed
teed55439262t_eed
teredo7310782teredo
termed94816702termed
tewed94718532tewed
thread105011092thread
three87526912three
threw1117315712threw
tided76322512tided
tied55535212t_ied
tiered73613972tiered
tiled64832942tiled
timed85223612timed
tined65434532tined
tire46143352tire_
tires55437492tires
tirled74714362tirled
toed56137042t_oed
toked105626492toked
toled65934922toled
toned65435342toned
toped85631312toped
tore47359322tore_
tores55352672tores
toted64929482toted
toured74216152toured
towed95134582towed
toyed96019802toyed
trad55630912t_rad
tread64821702t_read
tree47745812t_ree
treed65626732treed
tref77030992t_ref
trek86222312t_rek
trend64817452t_rend
tres46542902t_res
tret46653532t_ret
trey77228792t_rey
tried65026912tried
trod57627952t_rod
trued65117692trued
tsked105910032tsked
tubed85818042tubed
tuned64622312tuned
turd56027622tur_d
turfed103110962turfed
turned73914472turned
tweed94915092tweed
tye65837442ty_e_
tyee75131422ty_ee
tyees86019452tyees
tyer75323392ty_er
tyers86220052tyers
tyes76433372ty_es
tyke115720502tyke_
tykes125817062tykes
tyne76325052tyne_
tynes85920302tynes
type96223742type_
types105721062types
typey135511882typey
tyro76622362tyr_o
tyros85118592tyros
tythed13457502tythed
wared96339872wared
wired95327642wired
wyled124611842wyled
wyted12529472wyted

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 Limit538001421.76630464.3
3Display Results1421420.0304733.3
 (SQL Overall)1786911421.88994595.6
 
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.