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

136 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
galleries1031170(None) 
gallerias1047131gallerias
galleried1146921galleried
allergies10137782_allergies
fulleries1248722fulleries
galeres83514332ga_ler_es
galleins9258692galle_ins
galleria946472galleri_a
galleryites1552032galleryites
gallflies1344222gallflies
gallies84122712gall__ies
gauderies1147742gauderies
grilleries1145592grilleries
helleries122611682helleries
railleries1046642railleries
aeries64737783_a__eries
algerines1069083_algerines
allees64521483_alle__es
alleges84212573_alle_ges
allegories1185393_allegories
alleles73812033_alle_les
allergen9135893_allergen
allergens10145173_allergens
allergins10146383_allergins
allies63827673_all__ies
allures72913113_allur_es
amberies122514683_amberies
aperies9423203_a_peries
arteries8321483_arteries
bakeries14312193ba_keries
balladries1345193balladries
ballerina1146483ballerina
ballerinas1244593ballerinas
ballers94421013baller__s
ballies93725743ball__ies
batteries11615113batteries
butleries11710073butleries
cajoleries1944763cajoleries
callees94117783calle__es
callers94221963caller__s
calories102919553ca_lories
calvaries1449803calvaries
canneries11313083canneries
catteries11815523catteries
causeries11510643causeries
cauteries11615393cauteries
celeries10316313_celeries
collieries1248333collieries
cutleries1179213cutleries
cycleries1647033cycleries
dallies84023193dall__ies
dauberies1248033dauberies
diableries1344603diableries
drolleries1145443drolleries
eateries8324313ea_teries
faeries104118993fa__eries
fakeries1559833fa_keries
fallacies1446833fallacies
fallaleries1453113fallaleries
fallers103917993faller__s
flaneries1249563flaneries
fooleries1248743fooleries
gadgetries1344013gadgetries
gaieties9310183ga_ieties
galaxies1637163ga_laxies
galenites10129183ga_lenites
galere73716673ga_ler_e_
galettes93111153ga_lettes
galilees936333galile__es
gallamines1345493gallamines
gallantries1254123gallantries
gallates92815523gall_ates
galleass935053galle_ass
galleasses1163013galleasses
gallein8299043galle_i_n
galleons9258443galle_ons
gallery11468743galler__y
gallerying1543033gallerying
galleryite1452383galleryite
galletas9308133galle_tas
galleted1038213galle_ted
galleting1137633galleting
gallets83517403galle__ts
galleys11369713galle__ys
gallicizes2284833gallicizes
gallied94115003gall__ied
gallowses1374943gallowses
galluses936963gall_uses
galores82614333ga_lor_es
gantries91413783ga_ntries
gaolers83511563gaoler__s
gaucheries1644533gaucheries
gauntries1046033gauntries
gayeties1236883ga_yeties
gillers84216903giller__s
gillies84120963gill__ies
glazieries2043573glazieries
glories81915913g__lories
graperies1239613graperies
groceries1249503groceries
gullies84717313gull__ies
gunneries1047043gunneries
halteres113414593halter_es
helleris113010183helleri_s
jaggeries18136973jaggeries
japeries17311463ja_peries
mallees93315973malle__es
masteries111018493masteries
millerites1247933millerites
naperies10313903na_peries
palletise11127633palletise
palletises1247223palletises
palletizes2176443palletizes
pallettes1148803pallettes
pedleries1298783pedleries
pillories1189573pillories
psalteries1276563psalteries
rallies73823343rall__ies
rifleries1247683rifleries
saddleries1244573saddleries
salaries8319573sa_laries
sallies73227813sall__ies
sculleries1244833sculleries
sealeries9313133sealeries
slaveries1249683slaveries
tallies73624603tall__ies
tanneries9310423tanneries
valkyries1952633valkyries
varletries1346033varletries
voleries11313233_voleries
waggeries14127463waggeries
walkyries1942673walkyries
wallabies1445733wallabies
walleyes1435603walle_yes
wallies103320743wall__ies
wasteries121115343wasteries

Search took 7 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 Limit1486411366.22023897.3
3Display Results1361360.0632158.7
 (SQL Overall)1786911366.70326658.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.