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

241 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
dataries931403(None) 
ataxies142410012_ataxies
canaries10318942canaries
dairies84217732da_iries
daubries1136742daubries
dearies83526272d_earies
diaries83321952d_iaries
dietaries10410662dietaries
drearies92313412drearies
eateries8324322eateries
notaries8314932notaries
ratanies8312922ratanies
rotaries8315692rotaries
salaries8319592salaries
vagaries12310292vagaries
votaries11312012votaries
acarids105312243_acarids
acarines10314343_acarines
actuaries1147573actuaries
aeries64737783_a_eries
agarics10319943_agarics
ambaries123312383ambaries
ambries111614563_ambries
angaries9314393angaries
aperies9423203_aperies
apiaries10312733apiaries
arteries8321513arteries
atabrines1144463_atabrines
ataraxies1644723_ataraxies
ataxias14189343_ataxias
ataxics16196643_ataxics
atomies93918363_atomies
atonies75320953_atonies
atopies92816433_atopies
attires72312953_attires
attrites8311583_attrites
attrits7310633_attrits
autarkies1344773autarkies
avarices1337183_avarices
aviaries1139783aviaries
bakeries14312203bakeries
bastardies1365143bastardies
batteries11615133batteries
bawdries14136843bawdries
binaries10314183binaries
botanies10312853botanies
calories102919563calories
calvaries1449803calvaries
caries85147623__caries
carries94328013ca_rries
cataloes10311653cataloes
catamites1349363catamites
catarrhs1344343catarrhs
catbrier1236183catbrier
catbriers1344153catbriers
catenaries1248673catenaries
catharses1446413catharses
catteries11815553catteries
catties94023053cat_ties
cauteries11615403cauteries
cavalries1446363cavalries
claries93422203_claries
coteries10422713coteries
covaries13413253covaries
daddies103414943da_ddies
dahabieh1742493dahabieh
dahabiehs1841473dahabiehs
dailies84219263da_ilies
dainties9312403dainties
daisies84217093da_isies
dalasis8810533dalasi_s
dallies84023193da_llies
damages11511283dama_ges
damars93815003damar__s
dandies94121443da_ndies
darbies104216983da_rbies
dares66146703d__ar_es
darics94314113d__arics
darkies124015753da_rkies
dassies84418663da_ssies
dastards10278083dastar_ds
database1143533database
databases1243913databases
datable101714233datable_
datary10310243datar__y
datelines1088863datelines
daters74827373dater__s
dates65639153dat___es
datives11310073dat_ives
daturas838783datur_as
daturic1047043daturi_c
dauberies1248033dauberies
dauties83315763da_uties
davies105020513d__avies
dawties113312703da_wties
daycares1454803daycar_es
dayflies1534463dayflies
daymares1445333daymar_es
deaneries10310833deaneries
dearie73319813d_earie_
decares102818533decar_es
decries103319813d_ecries
decuries11312223decuries
dekares122710873dekar_es
denarius948813denarius
derries83124623d_erries
descries11311923descries
detaches1439653detaches
details84214043deta_ils
detains83716093deta_ins
deterges101510093deterges
detrains9411763detrains
dhurries1255583dhurries
diatribes1245533diat_ribes
digamies1238643digamies
dittanies1045733dittanies
ditties83116983dit_ties
dories75232363d__ories
dotages92311793dota_ges
dotards937253dotar_ds
doweries12411933doweries
dowries114413983d_owries
dramadies1344813dramadies
draperies1249193draperies
drearier9297923drearier
dreariest10229123dreariest
dries64733673d___ries
duperies11312813duperies
durries83817353d_urries
duties74921903dut__ies
dwarves1434463d_warves
eatables10169793eatables
entries71523163ent_ries
estuaries946213estuaries
eutaxies1545793eutaxies
factories14810123factories
faeries104118993fa_eries
fairies103516043fa_iries
fakeries1559833fakeries
fantasies1298853fantasies
fatties103018203fat_ties
friaries11310083friaries
galaxies1637173galaxies
gantries91413803gantries
gramaries12128313gramaries
granaries10159883granaries
harries103525503ha_rries
jaggaries18135743jaggaries
japeries17311463japeries
katharses1643873katharses
kauries113613193ka_uries
laniaries9411223laniaries
latakias1245583latakias
laterites9715083laterites
laterizes18513033laterizes
latrias71913213lat_rias
latrines8515013lat_rines
litanies8310993litanies
maladies11311933maladies
malarias10313773malarias
malarkies1545123malarkies
mandataries1453823mandataries
marries93825293ma_rries
martyries1446563martyries
masteries111018513masteries
materiel10311263materiel
materiels1147843materiels
matres84522233mat_r_es
matrices12312083mat_rices
matrixes1738063mat_rixes
matures9314313matur_es
naperies10313903naperies
natures7311963natur_es
nectaries1149823nectaries
niteries8318383niteries
notarizes1848713notarizes
oratories9410653oratories
ostiaries948803ostiaries
outcries10313573outcries
ovaries10312653_ovaries
panfries13149213panfries
pantries101817393pantries
papacies1439483papacies
paries84742523__paries
parries93925853pa_rries
pastries101517423pastries
patsies93919483pat_sies
patties93425143pat_ties
ratables10159723ratables
ratafees1144143ratafees
ratafias1145323ratafias
ratifies11313513ratifies
retries74129073ret_ries
rhatanies1244983rhatanies
rosaries8312783rosaries
safaried1236253safaried
safaris101110663safari_s
salaried9311033salaried
sanitaries1049913sanitaries
sataras7315063satar_as
satires72617573satir_es
satirise8310683satirise
satirises9410193satirises
satirizes1849393satirizes
satoris7317253satori_s
satrapies1147723satrapies
satyrids1245623satyrids
sauries72821623sa_uries
savarins1139893savarins
savories11311273savories
sectaries11312243sectaries
stares66038753_star_es
starves104614553_starves
statuaries1054603statuaries
stories7324273_stories
sudaries9312753sudaries
sudatories1145683sudatories
tamarins10310843tamarins
tamaris9413603tamari_s
tardies84225863__tardies
tares57456563__tar_es
targes74524603__targes
tarres64723043__tarres
tarries73324263ta_rries
tatamis939723tatami_s
tatars64619793tatar__s
tatties74120343tat_ties
tawdries12136083tawdries
taxies135817333__taxies
tetanies8513553tetanies
tories65435883__tories
tries55742813__t_ries
uakaris1146633uakari_s
varies94330873__varies
vivaries1439263vivaries
wasteries121115363wasteries
wastries111212883wastries
watapes12228383wata_pes
waterier11312103waterier
wateriest12312243wateriest
wearies103020233_wearies

Search took 9 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 Filter1786911461620.436409841.7
2DLD Change Limit1461622417.79618748.3
3Display Results2412410.0962510.4
 (SQL Overall)1786912418.32821456.7
 
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.