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

187 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
perigees118950(None) 
perigee101113391perigee_
mergees104411232mer_gees
pedigrees1343372pedigrees
perigeal1147552perigeal
perigean1146352perigean
perigons11310082perigons
periques1937662periques
perishes13313752perishes
aeries64737783aeri__es
aerifies111313393aerifies
aerogels945593aerogels
aperies9423203aperi__es
bargees105415873bar_gees
beiges91014413be_ig_es
beignes10149243be_ignes
bergeres1189113ber_geres
berimes115216643beri_mes
besieges1146003besieges
bribees11409283_bribees
burgees104915893bur_gees
cerises94722253ceri_ses
cerites94823433ceri_tes
deriders102411853deriders
derides93420853deri_des
deringers1137183deringers
derivers123811363derivers
derives114017813deri_ves
designees1145003designees
devisees12358283devisees
dragees9359483_dragees
eeriness8311873eeriness
emigres1037673_emigres
epergnes1156713eper_gnes
eringoes937433_eringoes
ferities111416723ferities
friges104116483_frig_es
frisees104411693_frisees
garigues1034963garigues
greiges937733greig_es
kerogens1345763kerogens
mergee94018143mer_gee_
mergers103813423mer_gers
merges94122493mer_g_es
meringues1244393meringues
merises93421423meri_ses
negligees1142433negligees
obligees1143953obligees
parges94529543par_g_es
pargets105215193par_gets
paries84742523pari__es
parietes10714553parietes
parises94827193pari_ses
parishes13314763parishes
parities10522983parities
parolees104313993parolees
peages94321853pe_ag_es
pedicels1336253pedicels
pedicles1338683pedicles
pedigree1244883pedigree
pedigreed1442223pedigreed
peerages1189893peerag_es
peeries93623023peeri__es
peewees1236803pe_ewees
peises84125043pe_i_ses
pelages10714613pelag_es
pelisses1048483pelisses
pelites93821993peli_tes
penises9318193peni_ses
pensees9311203pe_nsees
percales12313803percales
perchers153611523perchers
perches143717953per_ches
perdues103511333per_dues
perdures11289683perdures
peres76246643per___es
perfidies1546603perfidies
perfumes1555893perfumes
perfuses1358663perfuses
periapses1346053periapses
periapts1237273periapts
periblem1445513periblem
periblems1543493periblems
pericopes1547873pericopes
periderm1346813periderm
periderms1444993periderms
peridots1138323peridots
perigon1039853perig_on
perigynies1643963perigynies
perigyny1742913perigyny
periled10316323peri_led
perillas10310833perillas
perilled11410113perilled
perilous10310693perilous
perils84121853peri__ls
perilunes1147173perilunes
perimeter1349563perimeter
perimeters1448603perimeters
perinea9313043peri_nea
perineal1049203perineal
perineum1246523perineum
periods10312243peri_ods
peripeties1448403peripeties
peripety1546193peripety
peripter1278753peripter
peripters1368123peripters
perique1837523perique_
peris75537073peri___s
perished14310093perished
peritus9311803peri_tus
periwigs1444193periwigs
perjures17268083perjures
perkiness15209173perkiness
perlites10316363perlites
permittees1444243permittees
permutes1238713permutes
perniones1148593perniones
perplexes2044683perplexes
perries93226603per_ries
perses85428063per__ses
perspexes2043843perspexes
pertness10310093pertness
perukes133210113per_ukes
perusers10328803perusers
peruses94018163per_uses
pervades1437353pervades
petioles10311643petioles
petites93820203peti_tes
petrifies14310363petrifies
pewees11311393pe__wees
pharisees1444633pharisees
pierogies1245873pierogies
pirogies1139423pirogies
pirogues1135473pirogues
pledgees12376283pledgees
pongees104212543p_ongees
porgies103017003por_gies
prees75937173p_r__ees
preggers12236833preggers
prerinses1138813prerinses
pricers113915063p_ricers
prices104524543p_ri_ces
prides94324183p_ri_des
priers84521193p_ri_ers
pries74339533p_ri__es
prigged12398933p_rigged
prigs85219703p_rig__s
primers114215673p_rimers
primes104225263p_ri_mes
princes113015153p_rinces
priseres10310823p_riseres
prises84133173p_ri_ses
prisses94816713p_risses
privets122910053p_rivets
privies122414263p_rivies
prizers183911843p_rizers
prizes173819813p_ri_zes
purees84721683pur__ees
purgers104714003pur_gers
purges94421763pur_g_es
purifies13311933purifies
purines94420773puri_nes
purities10316283purities
pyrites12812203pyri_tes
pyrogens1437293pyrogens
ragees74618663__ragees
refugees12476403refugees
remiges103015473remig_es
rerigged1136243rerigged
rerigs74014793rerig__s
rerises73525883reri_ses
retirees84611653retirees
sergers83815633ser_gers
serges74225973ser_g_es
seriates82620683seriates
series64540973seri__es
serines74229543seri_nes
serpigoes1243783serpigoes
tergites9310543tergites
veligers1237023veligers
vergers114412633ver_gers
verges104320183ver_g_es
verifies141313483verifies
verites103822263veri_tes
verities111418043verities
vertigoes1354703vertigoes
yperites13310153yperi_tes

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.423422437.4
2DLD Change Limit1461621877.92318447.8
3Display Results1871870.0762460.5
 (SQL Overall)1786911878.42221217.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.