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

246 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
perigee10111339(None) 
perigees1189501perigees
mergee94018142mer_gee
pedigree1244882pedigree
perigeal1147552perigeal
perigean1146352perigean
perigon1039852perigon
periled10316322periled
perinea9313032perinea
perique1837522perique
aerie54634603aeri__e
aeried74221863aeri_ed
aerier64823153aeri_er
aeries64737783aeri_es
aerogel836523aerogel
aperies9423203aperi_es
bargee94624443bar_gee
beige81515383be_ig_e
beiges91014413be_iges
beigne9148613be_igne
bergere1068913ber_gere
berime105317333beri_me
berimed124912283berimed
berimes115216643berimes
beringed1298173beringed
besiege1035413besiege
bribee104316363_bribee
burgee97120593bur_gee
cerise84822043ceri_se
cerises94722253cerises
cerite84724873ceri_te
cerites94823433cerites
deride84420033deri_de
derided102914253derided
derider93214973derider
derides93420853derides
deringer1038143deringer
derive103817043deri_ve
derived123912763derived
deriver114213913deriver
derives114017813derives
designee1087753designee
devisee113812713devisee
dragee84415603_dragee
eerie55228533eeri__e
eerier64320023eeri_er
emigre937053_emigre
epergne1046143eper_gne
epigene1037893_epigene
feriae95618603feri_ae
ferine96422583feri_ne
friges104116483_friges
frisee94217993_frisee
garigue935583garigue
greige847203greig_e
greiges937733greiges
kerogen1236093kerogen
merge84523693mer_g_e
merged104214953mer_ged
mergees104411233mer_gees
merger95016483mer_ger
merges94122493mer_ges
meringue1144333meringue
merises93421423merises
merited10313853merited
negligee1044273negligee
obligee1046863obligee
pardee93922023par_dee
parge85831853par_g_e
parged104922043par_ged
parges94529543par_ges
parget94529393par_get
paries84742513pari_es
parises94827183parises
parolee94119643parolee
peage84723573pe_ag_e
peages94321853pe_ages
pedicel1237813pedicel
pedicle1238973pedicle
pedigreed1442223pedigreed
pedigrees1343373pedigrees
peerage1089803peerag_e
peerages1189893peerages
peerie83617893peeri__e
peeries93623023peeri_es
peewee11311963pe_ewee
pegged114811913pe_gged
peined94918843pe_ined
peise75825773pe_i_se
peised94817683pe_ised
peises84125043pe_ises
pelage9515363pelag_e
pelages10714613pelages
pelisse967063pelisse
pelite84323003peli_te
pelites93821993pelites
penile82219603peni_le
penises9318193penises
pensee8417313pe_nsee
percale11314093percale
perched154713243perched
percher143313423percher
perches143717953perches
perdie94718513per_die
perdue93912633per_due
perdues103511333perdues
perdure10379623perdure
pere66450263per___e
perea75026443per__ea
peres76246643per__es
perfume1446503perfume
perfuse1247663perfuse
peri65636973peri___
periapt11313413periapt
periblem1445513periblem
pericope1447783pericope
periderm1346803periderm
peridia10312363peridia
peridot10514243peridot
perigons11310083perigons
perigyny1742913perigyny
peril75425953peri__l
perilla9311233perilla
perilled11410113perilled
perils84121853peri_ls
perilune1046983perilune
perimeter1349563perimeter
perineal1049193perineal
perineum1246523perineum
period9314983peri_od
periods10312243periods
peripety1546193peripety
peripter1278753peripter
periques1937653periques
peris75537073peri__s
perish114619063peri_sh
perished14310083perished
perishes13313753perishes
periti8319953peri_ti
peritus9311803peritus
periwig1345163periwig
perjure16327963perjure
perked134617693per_ked
perkier133813123perkier
perlite9317323perlite
perlites10316363perlites
permed115217353per_med
permittee1346683permittee
permute1138793permute
perplex1836153perplex
perries93226603perries
perse75429523per__se
perses85428063per_ses
perspex1834183perspex
perter84422283per_ter
peruke123210393per_uke
peruked14367893peruked
perukes133210113perukes
peruse84016843per_use
perused103112193perused
peruser93511373peruser
peruses94018163peruses
pervade1337023pervade
petiole9311303petiole
petite84320653peti_te
petites93820203petites
pewee10319973pe__wee
pharisee1347603pharisee
pirogen1038263pirogen
pirogue1045413pirogue
pledgee11359633pledgee
pongee94920193p_ongee
porgies103017003porgies
preaged11612333preaged
pree67044733p_r__ee
prerinse1038633prerinse
price93725413p_ri_ce
priced115018883p_riced
pricer103918293p_ricer
prices104524543p_rices
pricey134412633p_ricey
pride84724733p_ri_de
prided103618033p_rided
prides94324183p_rides
pried84426863p_ri_ed
prier75027763p_ri_er
pries74339533p_ri_es
prig75924873p_rig__
prigged12398933p_rigged
prigs85219703p_rig_s
prime96525603p_ri_me
primed115118913p_rimed
primer105118683p_rimer
primes104225263p_rimes
prince104114763p_rince
prise74632613p_ri_se
prised94322203p_rised
prisere9310943p_risere
prises84133173p_rises
prithee1239933p_rithee
privet113821343p_rivet
prize164718943p_ri_ze
prized184415393p_rized
prizer174714883p_rizer
prizes173819813p_rizes
puerile9310093pueri_le
puree74632843pur__ee
purge85324603pur_g_e
purged104918263pur_ged
purger94717233pur_ger
purges94421763pur_ges
purine85321893puri_ne
purines94420763purines
pyrite11913313pyri_te
pyrites12812203pyrites
pyrogen1337353pyrogen
ragee65432663__ragee
refugee115310943refugee
remiges103015473remiges
rerig64018483rerig__
rerigged1136243rerigged
rerigs74014793rerig_s
rerise64325633reri_se
rerisen73613643rerisen
rerises73525883rerises
retiree75019083retiree
serge64727473ser_g_e
serged84118773ser_ged
serger73819743ser_ger
serges74225973ser_ges
seriate73722473seriate
series64540973seri_es
serifed11811463serifed
serine65432673seri_ne
serines74229543serines
tergite8311003tergite
veliger1137313veliger
verge93419843ver_g_e
verged114815163ver_ged
verger104315703ver_ger
verges104320183ver_ges
verier94620963veri_er
verite94323443veri_te
verites103822263verites
yperite1249893yperi_te
yperites13310153yperites

Search took 8 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 Filter1786911340270.436409841.7
2DLD Change Limit1340272466.64020184.8
3Display Results2462460.0932645.2
 (SQL Overall)1786912467.16924925.5
 
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.