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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

219 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
penis7512932(None) 
lenis56326861lenis
peins76128061peins
pends85527191pends
penes75839221penes
pennis84315741pennis
pens65649641pen_s
peris75537071peris
aegis6316782aegis
anis45746462_anis
bends85628972bends
benes75536232benes
bennis84314802bennis
bens65945702ben_s
bents76033692bents
cedis84317082cedis
cents74730332cents
defis96717502defis
delis64928542delis
denes65639722denes
deni56929392deni_
denies74729642denies
denim85518842denim
denims95214322denims
dens55945072den_s
dents65031802dents
egis56520652_egis
ends56528522_ends
engs56121392_engs
ens37245922_en_s
fends96324972fends
fens76139762fen_s
finis86824262finis
genes65133092genes
genic85119392genic
genie66124922genie
genies75324942genies
genii64514172genii
genip84415202genip
genips9469942genips
genius74512922genius
gens55740072gen_s
gents65729612gents
genus65319832genus
hens75642572hen_s
hents87330742hents
kenos95220622kenos
kens85435232ken_s
kepis115313362kepis
leis45739602le_is
lends65326252lends
lenes54738522lenes
lenos56024862lenos
lens46146492len_s
levis85818552levis
lewis85315842lewis
lexis125916032lexis
mends84927692mends
menus75822842menus
metis75025902metis
minis75432982minis
munis75022002munis
nenes55329672nenes
opens76118552open_s
ornis54616772ornis
padis86227142padis
pains75138282pains
panes76148692panes
pangs84628662pangs
panic93923902panic
panics103815362panics
pans65855722pan_s
pants76536922pants
paris75145942paris
pavis106422732pavis
peags86122842peags
peaks114825622peaks
peals75235492peals
peans75437642peans
pears75138612pears
peas65755062pe_as
peats76140192peats
pechs125516202pechs
pecks135724432pecks
pecs84634102pe_cs
pedes85327282pedes
peds75835242pe_ds
peeks115021112peeks
peels75226422peels
peens76428192peens
peeps95822362peeps
peers75130272peers
pees65257372pe_es
pegs75531762pe_gs
pehs95625762pe_hs
pein65834942pe_in
peise75825772pe_ise
pekes114623562pekes
pekin111514422pekin
pekins121812232pekins
peles75738082peles
pelfs105016292pelfs
pelts76128812pelts
pelvis113610322pelvis
pen56558842pen__
penal75228372penal
pence94924452pence
pencil103712972pencil
pencils113011762pencils
pend75934532pen_d
pengo84317592pengo
pengos94612412pengos
penial84120892penial
penile82219602penile
penises9318192penises
penna74520202penna
penne75423852penne
penni74617902penni
pennia84412972pennia
pennies94218812pennies
penny105119452penny
pensil83013332pensil
pensils92811592pensils
pent66559072pen_t
peones83821042peones
peonies93620152peonies
peonism11611102peonism
peons75327182peons
pepos96620082pepos
peps85134512pe_ps
peres76246642peres
peri65636972peri_
peril75425952peril
perils84121852perils
perish114619062perish
perks115325802perks
perms95524512perms
pernio8513142pernio
perps95521482perps
pervs105117372pervs
pes57259782pe__s
pesos77221622pesos
pests75933272pests
petit74332652petit
pets66248332pe_ts
pewit104622792pewit
pewits112810682pewits
pews95731532pe_ws
phenix1837132phenix
phis95724902p_his
pikis115116392pikis
pilis75825202pilis
pinas75434452pinas
pines76048862pines
pings85830882pings
pinks115729382pinks
pins65558452pin_s
pints75936222pints
pis56362032p__is
plenish1239942plenish
plenism11310112plenism
plenist9314332plenist
pois66539042p_ois
polis74731162polis
ponds85323402ponds
pones74547042pones
pongs85526342pongs
ponies84833462ponies
pons65850602pon_s
precis103416702precis
psis68120342p_sis
pubis94616462pubis
pulis74225602pulis
punas74826752punas
pungs85422222pungs
punish111411502punish
punjis1536692punjis
punks114822682punks
puns66641482pun_s
punts75828002punts
puris75332022puris
pyins105815862pyins
pyxis17458632pyxis
ranis55235832ranis
reins56234562reins
reis45343232re_is
rends65129952rends
renig64518912renig
renigs74314592renigs
renin54830032renin
renins64526452renins
rents55935182rents
seis45542392se_is
semis74623532semis
sends65528242sends
spends94714472spends
tends65425582tends
tenia55324482tenia
tenias64720072tenias
tennis64015302tennis
tens45647412ten_s
tents56434212tents
tenuis64213082tenuis
upends9438762upends
veins84620492veins
vends95520892vends
venin85118662venin
venins93816702venins
vents86125932vents
venus84918902venus
wends95822812wends
wens76337932wen_s
xenia124814772xenia
xenias133712972xenias
xenic144114642xenic
yens75832262yen_s
yetis85418392yetis
yonis85020822yonis
zeins144715392zeins

Search took 3 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 Filter178691538000.0931921408.6
2DLD Change Limit538002191.93627789.3
3Display Results2192190.0633476.2
 (SQL Overall)1786912192.09285416.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.