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

329 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
piggins11301047(None) 
biggins113410691biggins
pidgins11259121pidgins
piggies113813481piggies
piggin103111091piggin_
pigging123614671pigging
biggies113813522biggies
biggin103710602biggin_
bigging122815882bigging
biggings13327472biggings
digging113513702digging
diggings12316622diggings
figging133313562figging
gigging93311772gigging
igging93212072_igging
jigging173011552jigging
leggins9259472leggins
lignins84010492lignins
muggins11248072muggins
noggins9288452noggins
pegging122811132pegging
pidgin10259812pidgin_
pigeons1039182pigeons
piggie103210772piggi_e
piggier113510002piggier
piggiest12259662piggiest
pigginess1375452pigginess
piggish14227702piggish
pigmies122610992pigmies
pigpens1235502pigpens
pigskins1544252pigskins
pinging113419552pinging
pipkins15328182pipkins
pippins10319752pippins
prigging13299092prigging
pugging122912542pugging
rigging103016332rigging
riggings11327132riggings
virgins1137862virgins
wigging133413832wigging
wiggings14316172wiggings
zigging193210532zigging
aggies83515513_aggies
aiblins9311473aiblins
algins74816433_algins
baggies113814853baggies
bagging123316983bagging
baggings13307523baggings
begging123012653begging
begins94415303_begins
biffins15358533biffins
biggie103810933biggi_e
biggish14247503biggish
biggity1435013biggity
bigwigs1443003bigwigs
bilging114212683bilging
binging113619383binging
biogens1038963biogens
biotins93114453biotins
bogging123615753bogging
buggies114613813buggies
bugging123515183bugging
citrins92614363citrins
cogging123513713cogging
diamins10312213diamins
diazins1739183diazins
diggers104413393diggers
digits84114533di_gits
digoxins1744293digoxins
dingies93618243dingies
dinging103618613dinging
dioxins1568003dioxins
doggies103613023doggies
dogging113312693dogging
egging93210983_egging
epigons1048183epi_gons
fagging133714763fagging
fagins10513863_fagins
fibrins1238633fibrins
ficins113513983fi_cins
fidging133910503fidging
firkins1437663firkins
fizgigs2142203fizgigs
fogging133513733fogging
frigging14268953frigging
fugging133912913fugging
gagging93013523gagging
gains65729513__gains
giggles103312933giggles
giggling10227043giggling
gins55543953___gins
grins65427223__grins
hagging133114683hagging
haggis11209513haggi_s
higgles123911803higgles
higgling14217163higgling
hinging123917123hinging
hogging133112803hogging
hugging132710633hugging
iggs66612673_igg__s
iodins74216523_iodins
jaggies163311083jaggies
jagging173311993jagging
jiggers164010183jiggers
jiggier16377823jiggier
jiggiest17277693jiggiest
jiggish19225943jiggish
jiggles164111433jiggles
jiggling18226363jiggling
jogging173211233jogging
joggings18264633joggings
jugging172910723jugging
kegging14328293kegging
kinging133115033kinging
kingpins1544903kingpins
kinins104014583ki_nins
lagging103316733lagging
laggings11298403laggings
leggin8268593leggin_
legging103912643legging
leggings11316193leggings
ligans76817733li_gans
lignans8398853lignans
lignin74911193lignin_
ligroins946823ligroins
linins65922143li_nins
lipins85016883li_pins
loggias9356783loggias
logging103316803logging
loggings11398233loggings
logins77820643_logins
luggies93011213luggies
lugging104114353lugging
margins103815193margins
miggles113512033miggles
miggs96311373migg__s
mignons1037863mignons
mirins83918903mi_rins
moggies113111723moggies
mogging123311493mogging
mugging122711793mugging
muggings13244593muggings
nagging102613043nagging
niacins938543niacins
niggers93111323niggers
niggles93512203niggles
niggling11227443niggling
nigglings12213733nigglings
nighing123410063nighing
noggin8288883noggin_
nogging103612723nogging
noggings11285743noggings
origins8310463origins
pagans95717923p_agans
paging104020403p_aging
pagings114411063p_agings
pains75138283p__ains
pangens103112063pangens
panging113319113panging
papains11312363papains
parging113318603parging
pargings123410163pargings
patins87528783p_atins
paulins9312613paulins
pavins114919663p_avins
pectins112315233pectins
peins76128063p__eins
pekins121812233p_ekins
penguins1145383penguins
pepsins11310433pepsins
phytins15317893phytins
pians75126963pi__ans
picking163418333picking
pickings17359383pickings
picnics13297343picnics
picolins1239853picolins
piecing12410453piecing
piecings1345343piecings
pieing93917653pi_eing
pieties9419223pieties
pigeon949413pigeon_
pigfish16217173pigfish
pigged114214153pigg_ed
piggeries13107893piggeries
piggery14266193piggery
piggy124011433pigg__y
piglets103311793piglets
piglike14157313piglike
pigment12510733pigment
pigments1337343pigments
pignus937953pi_gnus
pignuts1035613pignuts
pigouts1037593pigouts
pigpen1136583pigpen_
pigs76634223pi_g__s
pigskin1444353pigskin_
pigsties1139783pigsties
pigtails1146033pigtails
piing85218833pi__ing
piking133719643pi_king
pikis115116393pi_ki_s
pilgrims1344143pilgrims
piling95025593pi_ling
pilings103313613pi_lings
pilis75825203pi_li_s
pilling103722563pilling
pillions101610923pillions
pimping143812123pimping
pingers104020743pingers
pingoes105116523pingoes
pingos95317673ping_os
pings85830883ping__s
pining93726533pi_ning
pinions93413603pinions
pinkens13419643pinkens
pinkies133818263pinkies
pinking143918943pinking
pinkings15338143pinkings
pinnies93318443pinnies
pinning103417853pinning
pinons86019943pi_nons
pins65558453p___ins
pinyin112710613pinyin_
pinyons12299003pinyons
pions75826393pi__ons
piping114017453pi_ping
pipings12338253pi_pings
pipits104713063pi_pits
pipkin14248603pipkin_
pippin92810303pippin_
pipping113414743pipping
piquing1935873piquing
pirns76020093pi__rns
pirogies1139423pirogies
piscina1177043piscina
piscinas1275483piscinas
piscine11610973piscine
pishing134314373pishing
pissing103914803pissing
pistils93314303pistils
pistons93016373pistons
pithing134014053pithing
pities83828083pi_ties
pitmans11188743pitmans
pitons85319043pi_tons
pitting103618873pitting
pittings11349123pittings
pitying132910243pitying
pixies154915513pi_xies
plains85019593p_lains
plugging13306893plugging
pogies94123543p_ogies
pongids11347413pongids
ponging113416153ponging
popguns1234023popguns
poplins11313153poplins
porgies103017003porgies
postins93721203postins
priggish1544683priggish
priggism1444383priggism
priggisms1543253priggisms
progging132610383progging
pterins9812993pterins
puffins15278913puffins
puggier11309383puggier
puggiest12219223puggiest
pugginess1384963pugginess
puggish14265993puggish
puggries12166383puggries
punkins133111113punkins
purging113314183purging
purgings12347293purgings
purins83722653p_urins
purlins93415423purlins
pygmies15205673pygmies
pyins105815863p__yins
raggies93214733raggies
ragging103516683ragging
reagins84215643reagins
regains84316583regains
ricins83618703ri_cins
ridgils9326573ridgils
ridging104112983ridging
riggers93613843riggers
ringgits1044193ringgits
ringing93521283ringing
rugging102512763rugging
sagging103116103sagging
sieging92613203sieging
sighing123311663sighing
sigils73912363si_gils
signing92713963signing
signs65516323si_g_ns
simlins9311843simlins
singing93221423singing
siskins1159583siskins
smidgins12314843smidgins
spongins1136563spongins
sprigging1435893sprigging
swigging14337223swigging
tagging103014913tagging
tiepins939463tiepins
tiffins13327983tiffins
tiglons837343tiglons
tigons74112263ti_gons
tinging93619463tinging
togging103512743togging
trigging11299583trigging
tugging102611233tugging
twigging14305673twigging
veggies1237553veggies
vegging13308873vegging
vigias104110893vi_gias
vigils104210193vi_gils
violins10311453violins
virgin1038083virgin_
wagging133313353wagging
waggons1235503waggons
wigans104511703wi_gans
wigeons1136983wigeons
wiggier12418863wiggier
wiggiest13269013wiggiest
wiggles123312463wiggles
wiggling14217293wiggling
winging123718713winging
withins133511693withins
yogins105114103_yogins
zagging193210453zagging
zinging183513943zinging

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 Filter1786911340270.423422437.4
2DLD Change Limit1340273297.79617191.8
3Display Results3293290.1232674.8
 (SQL Overall)1786913298.34221420.6
 
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.