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

201 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
agarics1031994(None) 
agaric93513631agaric_
acarids105312242acarids
agamic113110562agamic_
agamids11317012agamids
agars66120642agar__s
agrias74315392ag_rias
angarias9310552angarias
angaries9314392angaries
ataxics16196642ataxics
avarice1238032avarice
avarices1337182avarices
darics94314112_darics
garlics1038012_garlics
vagaries12310292vagaries
aaliis6312903a_aliis
abasias9711013abasias
abatis84317933abati_s
abris75722603a_bri_s
acacias11510403acacias
acari75020283acari__
acarid95017073acari_d
acarine9316003acarine
acarines10314343acarines
acarus8312193acar_us
adagios945513adagios
aeries64737783a_eries
afars85716513afar__s
afrits9311903a_frits
again65218123aga_i_n
against838383aga_inst
agamas97413453aga_mas
agamid103710693agami_d
agamous1037943agamous
agapeic1244713agapeic_
agapes95212413aga_pes
agar58726413agar___
agarose838673agarose
agaroses938823agaroses
agas55938843aga___s
agates76121343aga_tes
agatize1739833agatize
agatizes1838863agatizes
agaves104611513aga_ves
agers65027853ager__s
aggadic1254813aggadic_
aggies83515513ag_gies
aggress935593aggress
aggros836553aggr_os
agios65919863ag__ios
agnails837003agnails
agnatic10310973agnatic_
agonic93515143agonic_
agonies83016623agonies
agoras7613343agor_as
agrafes1137523agrafes
agrarian948253agrarian
agrarians1045793agrarians
agravic1345893agravic_
agrees74915323ag_rees
agria65517143ag_ri_a
alanins7315803alanins
alarms85913053alar_ms
alarums9408923alarums
alcaics1137023alcaics
aldrins8310203aldrins
ambaries123312383ambaries
ambaris113112163ambari_s
ambries111614553ambries
amtracs1198883amtracs
anarch11310393anar_ch
anarchs1237093anarchs
angaria8311583angari_a
antics84621453a_ntics
anurias7312253anurias
anuric8812103anuric_
aperies9423203aperies
aphasics15257233aphasics
apiaries10312723apiaries
aporias9315153aporias
aquatics1945893aquatics
arabic10312733arabic_
arabica1147283arabica
arabicas1247193arabicas
aramids102810513aramids
arcs67834783__ar_cs
arctics1138953arctics
argalis84214193argali_s
arias55438023__arias
arils58732203__arils
arris56824683a_rri_s
asarums9467613asarums
ascarids11438503ascarids
ascaris93613323ascari_s
asdics9439863a_sdics
aspics104211563a_spics
astrict9614793astrict
astricts1049463astricts
ataraxics1842693ataraxics
atavic11189293atavic_
ataxias14189343ataxias
ataxic15169203ataxic_
ataxies142410013ataxies
atomics113110853atomics
atonics93613713atonics
attics84413283a_ttics
attrits7310613attrits
auguries947933auguries
auric74521733a_uric_
auris55331533a_uri_s
avails939693ava_ils
aviaries1139783aviaries
awaits96411953awa_its
awards107113453awar_ds
baldrics13164893baldrics
baric96125693_baric_
basics104915123_basics
bawdrics16153273bawdrics
calorics122810463calorics
cambrics1645253cambrics
canaries10318943canaries
carices114220953_carices
caries85147623_caries
claries93422203claries
clerics1149333clerics
daric85623113_daric_
dataries9314033dataries
dearies83526273dearies
diaries83321953diaries
dyadics1453473dyadics
fabrics1436093fabrics
fanatics1367183fanatics
gabies93820733_gabies
gadids95611823_gadids
gadis74825293_gadi_s
gains65729513_ga_ins
gaits65726013_ga_its
gamic103916203_gamic_
gamins94420043_gamins
garbs86321413_gar_bs
garish104516923_garish
garlic9310043_garlic_
gars55750743_gar__s
garths104111503_garths
grails77518783_grails
grains74223093_grains
grids75321393_g_rids
grigs75318193_g_rigs
grins65427223_g_rins
grips85520133_g_rips
grits65529583_g_rits
hagadic1445863hagadic_
hegaris11310433hegari_s
italics936993italics
jaggaries18135743jaggaries
laics76419253_la_ics
laris54737463_lari_s
lyrics11357943_lyrics
magics115311613_magics
malarias10313773malarias
manics103919933_manics
marcs95726623_mar_cs
margaric1346063margaric_
margarins1248293margarins
metrics11312363metrics
narcs76122023_nar_cs
naric76824173_naric_
naris55735293_nari_s
organics1146383organics
ovaries10312653ovaries
pagurids12144003pagurids
panics103815363_panics
paries84742513_paries
paris75145943_pari_s
quadrics2045653quadrics
quartics19216843quartics
rubrics1177093rubrics
safaris101110663safari_s
salaries8319573salaries
sarins63932623_sarins
saris54544953_sari_s
savarins1139893savarins
sferics1236133sferics
sharias102516003sharias
sharifs13279903sharifs
spagyrics1741523spagyrics
sparids103512123sparids
statics93314533statics
tamarins10310843tamarins
tamaris9413593tamari_s
tarocs84615663_tarocs
torics85118353_torics
tragics10338083tragics
uakaris1146633uakari_s
uraris63817273urari_s
vagarious1344613vagarious
varias95019903_varias
varices123313573_varices
varies94330873_varies
vitrics12198553vitrics
wearies103020223wearies

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.1561145455.1
2DLD Change Limit1340272016.96619240.2
3Display Results2012010.0802512.5
 (SQL Overall)1786912017.20224811.3
 
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.