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 “agarose” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

167 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
agarose83867(None) 
agaroses938821agaroses
acarbose1244682acarbose
acerose9310902acerose
agars66120642agar_s_
aggros836552aggros_
amarone9311202amarone
arose55832082__arose
garote7717952_garote
gyrose105310252_gyrose
abalone938903abalone
abase76023483aba__se
acarboses1345083acarboses
acarine9316003acarine
acaroid103512313acaroid
acarus8312193acarus_
acaulose1044383acaulose
acetose938843acetose
acinose938583acinose
across8312643a_cross
adipose1036653adipose
aerobe8412403a_erobe
afars85716513afar_s_
against838383against
agamas97413453agamas_
agamete1037403agamete
agamous1037943agamous
agapae9388043aga_pae
agape85614843aga__pe
agapes95212413agapes_
agar58726413agar___
agaric93513643agar_ic
agarics10319943agarics
agas55938843aga__s_
agate66525153aga__te
agates76121343agates_
agatize1739833agatize
agatoid948623agatoid
agave95314033aga__ve
agaves104611513agaves_
agaze156113663aga__ze
agers65027853ager_s_
aggrade1035643aggrade
aggress935593aggress
aggro738013aggro__
agios65919863ag_ios_
aglare7312433aglar__e
agone65924553ag__one
agonise83112693agonise
agorae7511203agor_ae
agoras7613343agoras_
agorot7415003agoro_t
agoroth1145143agoroth
agrafe1038093ag_rafe
agrafes1137523agrafes
agraffe1443333agraffe
agree65226033ag_r_ee
agrees74915323ag_rees
ahorse9311513ahor_se
alamode1038163alamode
alamos8415003alamos_
alarms85913053alarms_
aldose7311093a_ldose
algaroba1142053algaroba
amarones10311353amarones
amauroses1144473amauroses
amoroso946093amoroso
amylose1237193amylose
anaerobe1044823anaerobe
anagoge9166643anagoge
analyse10208893analyse
anatase738943anatase
andros7313303andros_
angaries9314393angaries
anginose945903anginose
angulose945173angulose
antrorse846933antrorse
apagoge11164683apagoge
appose10411993a_ppose
apprise11310193apprise
approve14116603approve
apyrase1236363apyrase
araroba945763araroba
arenose7311373arenose
ariose64818723a_riose
arise56436433__arise
arkose104911343a_rkose
arouse65019983__arouse
arse46539273__ar_se
avarice1238033avarice
averse95811183aver_se
awardee1137563awardee
awards107113453awards_
aware86420023awar__e
bagasse1035143baga_sse
brose75227033__brose
carouse9614423_carouse
carse74934333_car_se
cirrose937473cirrose
claroes93113743claroes
claros84015113claros_
coarse84813903coar_se
erose55727283__erose
faros85532023_faros_
galore73514873_galore
galosh1038573_galosh
galoshe1135413_galoshe
garage8314513_garage
garble94118453_garble
garbs86321413_garbs_
gargle84215463_gargle
garish104516933_garish
garoted9710133_garoted
garotes8614573_garotes
garotte868703_garotte
garrote8510113garrote
gars55750743_gar_s_
giros65722653_giros_
goose65925903_g_oose
gorse65926813_gor_se
grope84821613_g_rope
gross65421693_g_ross
grosz154814093_g_rosz
grosze16457733_g_rosze
grouse74315023_g_rouse
grove95219333_g_rove
gyrase10508773_gyrase
gyros95616483_gyros_
hagrode1236453hag_rode
hearse94114283hear_se
hoarse94411323hoar_se
kaross101910013_kaross
lanose6313593_lanose
leprose938553leprose
marse76231153_mar_se
megadose1244493megadose
morose85116243_morose
narcose95910393_narcose
necrose939733necrose
operose939433operose
paganise1139663paganise
parole84425253_parole
parse75236993_par_se
pharos11312063pharos_
pharoses13310323pharoses
porose84818743_porose
prose75835123__prose
ramose8314403_ramose
rearouse839383rearouse
rerose63320853_rerose
rose46148903___rose
sagamore1144353sagamore
saguaros944973saguaros_
sarode75317513_sarode
saros55238063_saros_
saroses73619333_saroses
scapose1147753scapose
scariose1037593scariose
sparse84516343spar_se
starnose8136693starnose
sucrose939313sucrose
taros55640823_taros_
torose64317693_torose
uprose82311483_uprose
vadose1037963_vadose
vagaries12310293vagaries
vamose1159283_vamose

Search took 8 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 Filter1786911340270.403443402.0
2DLD Change Limit1340271676.87619492.0
3Display Results1671670.0632650.8
 (SQL Overall)1786911677.34224338.2
 
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.