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 “gauderies” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

81 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
gauderies114774(None) 
causeries11510642causeries
cauteries11615392cauteries
dauberies1248032dauberies
galleries10311702galleries
gaucheries1644532gaucheries
gaudies9311972gaud__ies
gauntries1046032gauntries
pruderies1247872pruderies
ruderies9311332_ruderies
aeries64737783_a__eries
amberies122514683_amberies
aperies9423203_a_peries
arteries8321483_arteries
auberges1146673_auberges
auguries947933_auguries
bakeries14312193ba_keries
batteries11615113batteries
baudekins1642433baudekins
bawdries14136843bawd_ries
binderies12311683binderies
canneries11313083canneries
catteries11815523catteries
caudexes1843843caude_xes
causerie1078273causerie_
cauterizes2197993cauterizes
daubries1136743dau_bries
drudgeries1343273drudgeries
duperies11312813_duperies
eateries8324313ea_teries
faeries104118993fa__eries
fakeries1559833fa_keries
feudaries1345883feudaries
gadders103611503gadder__s
gadflies1334733ga_dflies
gadgetries1344013gadgetries
gaieties9310183ga_ieties
galeres83514333ga_ler_es
gallerias1047133gallerias
galleried1146923galleried
gandered112211173gander_ed
gandering122111293gandering
ganders93521703gander__s
gantries91413783ga_ntries
gardenias1145403gardenias
garderobes1452293garderobes
gaucherie1543423gaucherie_
gaudery1234743gauder__y
gaudier938453gaud__ier
gaudiest1039393gaud__iest
gaugers94211713gauger__s
gayeties1236883ga_yeties
genderizes2176003genderizes
geodesies1144593geodesies
glazieries2043573glazieries
graperies1239613graperies
grinderies1245833grinderies
groceries1249503groceries
gruyeres1242863gruyer_es
gunneries1047043gunneries
gurries83515953g_u_rries
jaggeries18136973jaggeries
japeries17311463ja_peries
kauries113613193kau__ries
lauders84012893lauder__s
laundries1045563laundries
maderizes2148953ma_derizes
masteries111018493masteries
maumetries1446023maumetries
naperies10313903na_peries
pauperizes2344773pauperizes
queries16315873_qu_eries
saddleries1244573saddleries
sauries72821623sau__ries
sauternes947023sauternes
sudaries9312753_sudaries
tanneries9310423tanneries
tawdries12136083tawd_ries
waggeries14127463waggeries
wardenries1444433wardenries
wasteries121115343wasteries

Search took 10 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.410435831.7
2DLD Change Limit148641818.60617271.8
3Display Results81810.0801012.5
 (SQL Overall)178691819.09619645.0
 
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.