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

120 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
deaneries1031083(None) 
beaneries11310901beaneries
dearies83526272dea__ries
draperies1249192draperies
eateries8324312_eateries
ferneries1239042ferneries
flaneries1249562flaneries
henneries1248642henneries
sealeries9313132sealeries
veneries112815032ve_neries
aeries64737783__a_eries
anergies9310453__anergies
aperies9423203__aperies
bakeries14312193_bakeries
beanies93821093bean__ies
braveries1439103braveries
canaries10318943_canaries
canneries11313083canneries
celeries10316313ce_leries
chanceries1747653chanceries
chantries14310293chantries
creameries1446673creameries
dairies84217733d_a_iries
dandies94121443d_an_dies
dataries9314033d_ataries
dauberies1248033dauberies
daubries1136743d_aubries
deaconries1345163deaconries
deadeyes1344563deade_yes
deadnesses1238943deadnesses
deaerates10313643dea_erates
deafnesses1436223deafnesses
dealers84118613dealer__s
deanery1137613deaner__y
deanships1545993deanships
dearie73319813dea__rie_
dearnesses1139583dearnesses
decenaries1348123decenaries
decencies1448943decencies
decries103319803de__cries
decuries11312223de_curies
deliveries1446013deliveries
demerges12129503de_merges
demerits11310763de_merits
denarius948813de_narius
dendrites1147933de_ndrites
denies74729643de_n__ies
derries83124623de__rries
descries11311923de_scries
deserves12109893de_serves
deterges101510093de_terges
deuterides1245253deuterides
devilries1345253devilries
dewberries1643533dewberries
diableries1344603diableries
diaries83321953dia__ries
dodgeries1246593dodgeries
doggeries1246673doggeries
doweries12411933d_oweries
dramedies1345123dramedies
draperied1344983draperied
drearies92313413drea__ries
duperies11312813d_uperies
emeries91620023_e_meries
emperies12314563_emperies
enemies9313693_e_nemies
energies9310783_e_nergies
entries71523163_e_ntries
faeries104118993_fa_eries
fakeries1559833_fakeries
fineries112416743_fineries
flanerie1146913flanerie_
gantries91413783_gantries
generics11118793ge_nerics
gentries91315263ge_ntries
granaries10159883granaries
graperies1239613graperies
greeneries1167073greeneries
gunneries1047043gunneries
helleries122611683helleries
henries102718283he_n_ries
imageries1246783imageries
japeries17311463_japeries
joineries1648103joineries
knaveries1645013knaveries
leaners73718173leaner__s
lecheries1449073lecheries
meaners94415243meaner__s
meanies93620743mean__ies
menageries1345853menageries
merceries13410043merceries
naperies10313903_naperies
nunneries947113nunneries
orangeries11116943orangeries
panfries13149203_panfries
pantries101817393_pantries
pedantries1345683pedantries
pedleries1298783pedleries
peeries93623023pe__eries
penuries10311663pe_nuries
pineries102419083_pineries
reentries9311763reentries
refineries1347063refineries
reveries112518513re_veries
sceneries1149393sceneries
sentries81318053se_ntries
slaveries1249683slaveries
swanneries1344363swanneries
tanneries9310423tanneries
teaberries1245123teaberries
tenantries1045673tenantries
ternaries9311643ternaries
traceries11312863traceries
turneries948493turneries
veeries102916893ve__eries
vineries112716043_vineries
weaners104613833weaner__s
wearies103020223wea__ries
wernerites1344943wernerites
wineries112316533_wineries

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 Filter1786911486410.420425454.8
2DLD Change Limit1486411206.78321913.8
3Display Results1201200.0462608.7
 (SQL Overall)1786911207.24924650.4
 
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.