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

130 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
theres9652547(None) 
heres86245901_heres
thebes115914491thebes
themes115319251themes
there87527391there_
thermes126214611thermes
therms115914871therms
theses96517971theses
threes97117321threes
wheres125917431wheres
adheres11310162adheres
ceres75540012_ceres
chares115631802chares
cheers114518912cheers
cherts115617232cherts
chevres15379792chevres
chores114828022chores
coheres122917692coheres
ethenes103313872ethenes
ethers94518412ether_s
feres86038182_feres
freres94716172freres
ghees95215552ghe_es
haeres94017032haeres
hares86255542_hares
hebes105521672_hebes
hemes105031082_hemes
herbs105520502_herbs
herds96424682_herds
here76447102_here_
heresy125011232_heresy
herls85226432_herls
herms105626432_herms
herns84825582_herns
heroes94923822_heroes
heros84930862_heros
herpes115517322_herpes
hers75844872_her_s
hexes155123042_hexes
hires86134342_hires
inheres10315172inheres
meres75143572_meres
others93918002other_s
peres76246642_peres
rhemes115913182rhemes
seres55448892_seres
shares95236412shares
sheers94322402sheers
sherds105614722sherds
shires95225572shires
shores94830412shores
spheres123114352spheres
steres63929532steres
tares57456562t_ares
tarres64723042tarres
tees45353582t_e_es
teles54536002t_eles
terces83921412t_erces
terms75523472t_erms
ternes65422902t_ernes
terns55226872t_erns
terse55026822t_erse
thanes94918982thanes
tharms115712242tharms
theatres11298632theatres
thebe107515432thebe_
thee78039062the_e_
thefts12387922thefts
thegns10547432thegns
theines104013232theines
theins95015422theins
theirs94610352theirs
theme105921732theme_
themed125912582themed
thens85921832the_ns
theorem1236272theorem
theorems1344692theorems
theories11311592theories
thereat104315242thereat
thereby1534632thereby
therein102310352therein
thereof13168062thereof
thereon10199262thereon
thereto1038992thereto
therm106018022ther_m
therme115814992therme
thermel12569892thermel
thermels13607762thermels
thermos124610752thermos
these86519012these_
thesis94913732thesis
thesps11448262thesps
thetas93011572thetas
thews117416192the_ws
thieves1346902thieves
thirds10438602thirds
thirls95012062thirls
tholes94919782tholes
thorns95314102thorns
thorpes125010352thorpes
thorps113610892thorps
three87526912th_ree
threep115910112threep
threeps12687042threeps
thresh12276862th_resh
threw1117315712th_rew
throes97518672throes
thurls9418712thurls
thymes144810742thymes
thyrse1235132thyrse
thyrses1335022thyrses
tierces93710452tierces
tiered73613972tiered
tiers55526522tier_s
tires55437492t_ires
titres64718932titres
tmeses85712242tmeses
tores55352672t_ores
trees55835762tre_es
tres46542902t__res
tsores65113662tsores
tuyeres10417792tuyeres
twerps11345152twerps
tyees86019452tye_es
tyers86220052tyer_s
tyres84725232t_yres
where117019422where_
whereas13448902whereas
wherves16548052wherves
whores125617102whores

Search took 3 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 Filter178691825510.343520965.0
2DLD Change Limit825511302.50033020.4
3Display Results1301300.0462826.1
 (SQL Overall)1786911302.88961852.2
 
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.