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

156 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
pirogies113942(None) 
pierogies1245871pierogies
pirogues1135471pirogues
ironies7517422_ironies
parodies11313692parodies
piggies113813482pi_ggies
piracies12312642piracies
pirogen1038262pirog_en
pirogi9299012pirogi__
pirogue1045412pirogue_
piroques1944352piroques
pogies94123542p__ogies
porgies103017002por_gies
priories10312452priories
proxies163014932p_roxies
apiologies1339063apiologies
apologies12311193apologies
baronies10315023baronies
biggies113813523bi_ggies
biologies12311183biologies
birdies104016213bir_dies
birkies133712433bir_kies
bogies94724313__bogies
boogies103719013_boogies
brionies10310543brionies
brogues10719823_brogues
corodies11313693corodies
cronies9622503_cronies
dingies93618243di_ngies
dipodies1238413dipodies
dirges84915103dir_g_es
dirties83119383dir_ties
dogies85022253__dogies
drogues9398393_drogues
epibolies1345123epibolies
epilogues1243833epilogues
epirogenies1464373epirogenies
eulogies938523eulogies
eurokies1246333eurokies
fogies104118063__fogies
girlies83013703gir_lies
girolles935523girolles
irones64724013_iro_nes
ironizes17510373_ironizes
ivories10310713_ivories
mirages102213533mirag_es
noogies82814583_noogies
ologies8615023_ologies
oologies9312993oologies
orgies72316093_or_gies
parges94529543par_g_es
paries84742513par__ies
parities10522973parities
parodied1238333parodied
parolees104313983parolees
paroles95025883paro_les
parotids112610413parotids
parries93925843par_ries
parties93230863par_ties
peonies93620153p_eonies
perigees1189503perigees
peroxides1947493peroxides
peroxids1837453peroxids
perries93226603per_ries
phonies123717513p_honies
picolines1339623picolines
picolins1239853picolins
picotees1247113picotees
pidgins11259123pi_dgins
pierogi1054723pierogi__
pieties9419223pi_eties
piggie103210773pi_ggie_
piggier113510003pi_ggier
piggiest12259663pi_ggiest
piggins113010473pi_ggins
pigmies122610993pi_gmies
pigsties1139783pigsties
pillories1189573pillories
pineries102419083pineries
pingoes105116523pi_ngoes
pinkies133818263pi_nkies
pinnies93318443pi_nnies
pinocles1248693pinocles
pinoles93418703pino_les
pinones94717073pino_nes
pipages1289423pipag_es
piraguas1144453piraguas
pirates93020333pir_ates
pirog83913673pirog___
piroghi13303843pirog_hi
piroque1844353piroque_
pishoges1446953pishog_es
pishogues1543003pishogues
pisolites1149383pisolites
pities83828083pi__ties
pixies154915513pi__xies
pokies125921333p__okies
polies84034583p__olies
ponies84833463p__onies
porkies133416493por_kies
porkpies1636193porkpies
posies84431433p__osies
premies113823063p_remies
prexies163415003p_rexies
pries74339533p_r__ies
prissies101712003prissies
privies122414263p_rivies
probes104119453p_ro_bes
probits112712573p_robits
prodigies1346953p_rodigies
profiles133211233p_rofiles
profits122911243p_rofits
progenies12314123p_rogenies
progged12409803p_rogged
progger11319373p_rogger
proggers12258163p_roggers
progress1137023p_rogress
progs86624153p_rog__s
proles84627203p_ro_les
prolines102619693p_rolines
promines123018803p_romines
promise113415843p_romise
promises122916763p_romises
propines122618933p_ropines
prorogues1244883prorogues
proses84733473p_ro_ses
prosier93817483p_rosier
prosiest10416523p_rosiest
prosses94019513p_rosses
prossies101515223p_rossies
prosties101421193p_rosties
proves114322253p_ro_ves
provides1439883p_rovides
purges94421763pur_g_es
purifies13311923purifies
purities10316283purities
pyrogen1337353pyrog_en
pyrogens1437293pyrogens
pyrolizes2347233pyrolizes
pyrologies16310013pyrologies
pyrones123113303pyro_nes
pyronines1458323pyronines
pyropes142210193pyro_pes
pyrosis12411653pyrosi_s
pyrosises1457583pyrosises
rogues74617673__rogues
simonies10311113simonies
stogies8413693_stogies
trilogies1048173trilogies
viragoes1245233viragoes
virgins1137863vir_gins
viroids1137923viro_ids
virologies1447213virologies
viroses10310533viro_ses
virosis1039023virosi_s
wicopies1545983wicopies

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.470380193.6
2DLD Change Limit1461621567.51619446.8
3Display Results1561560.0632476.2
 (SQL Overall)1786911568.04922200.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.