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
agarose83865(None) 
agaroses938821agaroses
acarbose1244682acarbose
acerose9310892acerose
agars66120642agar_s_
aggros836542aggros_
amarone9311192amarone
arose55832082__arose
garote7717942_garote
gyrose105310252_gyrose
abalone938893abalone
abase76023483aba__se
acarboses1345083acarboses
acarine9316003acarine
acaroid103512303acaroid
acarus8312193acarus_
acaulose1044383acaulose
acetose938843acetose
acinose938573acinose
across8312643a_cross
adipose1036653adipose
aerobe8412403a_erobe
afars85716513afar_s_
against838383against
agamas97413443agamas_
agamete1037393agamete
agamous1037923agamous
agapae9388043aga_pae
agape85614843aga__pe
agapes95212413agapes_
agar58726413agar___
agaric93513623agar_ic
agarics10319943agarics
agas55938843aga__s_
agate66525143aga__te
agates76121333agates_
agatize1739833agatize
agatoid948603agatoid
agave95314033aga__ve
agaves104611513agaves_
agaze156113663aga__ze
agers65027853ager_s_
aggrade1035633aggrade
aggress935593aggress
aggro738003aggro__
agios65919863ag_ios_
aglare7312423aglar__e
agone65924553ag__one
agonise83112693agonise
agorae7511203agor_ae
agoras7613343agoras_
agorot7414993agoro_t
agoroth1145133agoroth
agrafe1038093ag_rafe
agrafes1137523agrafes
agraffe1443333agraffe
agree65226033ag_r_ee
agrees74915323ag_rees
ahorse9311513ahor_se
alamode1038153alamode
alamos8415003alamos_
alarms85913053alarms_
aldose7311093a_ldose
algaroba1142033algaroba
amarones10311353amarones
amauroses1144473amauroses
amoroso946093amoroso
amylose1237183amylose
anaerobe1044823anaerobe
anagoge9166643anagoge
analyse10208893analyse
anatase738943anatase
andros7313303andros_
angaries9314383angaries
anginose945903anginose
angulose945163angulose
antrorse846923antrorse
apagoge11164683apagoge
appose10411993a_ppose
apprise11310193apprise
approve14116603approve
apyrase1236363apyrase
araroba945763araroba
arenose7311373arenose
ariose64818723a_riose
arise56436433__arise
arkose104911343a_rkose
arouse65019983__arouse
arse46539273__ar_se
avarice1238033avarice
averse95811183aver_se
awardee1137553awardee
awards107113453awards_
aware86420023awar__e
bagasse1035143baga_sse
brose75227033__brose
carouse9614423_carouse
carse74934333_car_se
cirrose937473cirrose
claroes93113733claroes
claros84015113claros_
coarse84813893coar_se
erose55727273__erose
faros85532023_faros_
galore73514843_galore
galosh1038553_galosh
galoshe1135393_galoshe
garage8314513_garage
garble94118453_garble
garbs86321413_garbs_
gargle84215463_gargle
garish104516923_garish
garoted9710133_garoted
garotes8614563_garotes
garotte868703_garotte
garrote8510103garrote
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_
hagrode1236443hag_rode
hearse94114273hear_se
hoarse94411323hoar_se
kaross101910013_kaross
lanose6313593_lanose
leprose938543leprose
marse76231153_mar_se
megadose1244473megadose
morose85116243_morose
narcose95910383_narcose
necrose939723necrose
operose939433operose
paganise1139663paganise
parole84425253_parole
parse75236993_par_se
pharos11312063pharos_
pharoses13310313pharoses
porose84818743_porose
prose75835123__prose
ramose8314403_ramose
rearouse839363rearouse
rerose63320843_rerose
rose46148903___rose
sagamore1144343sagamore
saguaros944963saguaros_
sarode75317513_sarode
saros55238063_saros_
saroses73619333_saroses
scapose1147753scapose
scariose1037593scariose
sparse84516343spar_se
starnose8136683starnose
sucrose939303sucrose
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.1401276364.3
2DLD Change Limit1340271677.22018563.3
3Display Results1671670.0632650.8
 (SQL Overall)1786911677.42324072.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.