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

114 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
sealeries931313(None) 
beaneries11310902beaneries
celeries10316312ce_leries
deaneries10310832deaneries
eateries8324312_eateries
helleries122611682helleries
pedleries1298782pedleries
salaries8319572s_alaries
sealers74323552sealer__s
slaveries1249682slaveries
aeries64737783__a_eries
aperies9423203__aperies
bakeries14312193_bakeries
belfries1336983be_lfries
braveries1439103braveries
butleries11710073butleries
calories102919553_calories
creameries1446673creameries
cutleries1179213cutleries
cycleries1647033cycleries
dealers84118613dealer__s
dearies83526273dea__ries
diableries1344603diableries
draperies1249193draperies
elegies81312903_e_legies
emeries91620023_e_meries
emperies12314563_emperies
faeries104118993_fa_eries
fakeries1559833_fakeries
fealties1139993feal_ties
ferneries1239043ferneries
flaneries1249563flaneries
fooleries1248743fooleries
fulleries1248723fulleries
galeres83514333_galer_es
galleries10311703galleries
graperies1239613graperies
healers104319463healer__s
helleris113010183helleri_s
henneries1248643henneries
heraldries1443973heraldries
imageries1246783imageries
japeries17311463_japeries
jewelries1943033jewelries
knaveries1645013knaveries
lealties8310793leal_ties
lecheries1449073lecheries
mealies92821933meal__ies
menageries1345853menageries
merceries13410043merceries
naperies10313903_naperies
peddleries14104073peddleries
pedlaries12108783pedlaries
peeries93623023pe__eries
pelerines11311843pe_lerines
peltries10313023pe_ltries
psalteries1276563psalteries
psaltries1185743psaltries
realities9316313realities
realties8514853real_ties
replevies1465493replevies
revelries1246923revelries
reveries112518513re_veries
rifleries1247683rifleries
saddleries1244573saddleries
safeties1139163s_afeties
salaried9311023s_alaried
salifies11314793s_alifies
sallies73227813s_al_lies
salties73725773s_al_ties
saltires83112423s_altires
sauries72821623s_a_uries
savageries1444253savageries
savories11311273s_avories
scalares103210983scalar_es
scalers93817263scaler__s
sceneries1149393sceneries
sclerites1139443s_clerites
sculleries1244833sculleries
seahorses1246163seahorses
sealer63928963sealer___
sealery104011053sealer__y
sealskins1343253sealskins
seamers94719433seamer__s
seaters74028943seater__s
seawares1139333seawar_es
secrecies1346913secrecies
sectaries11312243sectaries
selenides10178193se_lenides
selenites91312083se_lenites
selkies113513353se_l_kies
sellers73721313seller__s
sentries81318053se_ntries
series64540973s___eries
serries73925353se__rries
sesterces1147873sesterces
smelteries1246163smelteries
sorceries1149933sorceries
spareribs1353283spareribs
sphalerites1652803sphalerites
spiceries1349313spiceries
stealers83412203stealer__s
stemmeries1445173stemmeries
subseries11312933subseries
surgeries10311363surgeries
swanneries1344363swanneries
teaberries1245123teaberries
traceries11312863traceries
vealers103214293vealer__s
veeries102916893ve__eries
veneries112815033ve_neries
voleries11313233_voleries
wearies103020223wea__ries
zealotries1944353zealotries

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 Filter1786911486410.423422437.4
2DLD Change Limit1486411147.75019179.5
3Display Results1141140.0462478.3
 (SQL Overall)1786911148.21921741.2
 
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.