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

312 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
pipkins1532818(None) 
pipkin14248601pipkin_
pippins10319751pippins
firkins1437662firkins
kipskins1343262kipskins
limpkins1644232limpkins
lipins85016882lip_ins
napkins1336672napkins
papains11312362papains
pekins121812232p_ekins
pepsins11310432pepsins
picking163418332picking
pickings17359382pickings
pidgins11259122pidgins
piggins113010472piggins
pigskins1544252pigskins
piking133719642pi_king
pikis115116392pi_ki_s
pinkens13419642pinkens
pinkies133818262pinkies
pinking143918942pinking
pinkings15338142pinkings
piping114017452pip_ing
pipings12338252pip_ings
pipits104713062pip_its
pippin92810302pippin_
pipping113414742pipping
poplins11313152poplins
pumpkins1843852pumpkins
punkins133111112punkins
siskins1159582siskins
aiblins9311473aiblins
biffins15358533biffins
biggins113410693biggins
bikies124515163bi_kies
biking135018173bi_king
bikini12418913bi_kini
bikinis13346203bi_kinis
bilking144413553bilking
biotins93114453biotins
birkies133712433birkies
bodkins1438313bodkins
bumkins15318013bumkins
bumpkins1843703bumpkins
buskins133310943buskins
calkins133814873calkins
caplins113515993caplins
catkins133012563catkins
cipolins1238033cipolins
citrins92614363citrins
diamins10312213diamins
diazins1739183diazins
dickens144410133dickens
dickies143416343dickies
dicking153617613dicking
diking124320243di_king
dinkies123716033dinkies
dinking133618283dinking
dioxins1568003dioxins
dipping134014833dipping
dirking133812603dirking
disking134615493disking
eikons1038503ei_kons
emptins1179403emptins
fibrins1238633fibrins
ficins113513983fi_cins
finking154016603finking
firkin1337823firkin_
gaskins123510773gaskins
gipons9389603gip_ons
gipping133813123gipping
gipsies1039903gipsies
griskins1335953griskins
hickies163614743hickies
hiking143617103hi_king
hipline12311423hipline
hiplines13310593hiplines
hippies142813743hippies
hipping153915103hipping
ikons96311013_i_kons
inking115119053_inking
iodins74216523_iodins
irking114611753_irking
jerkins18358253jerkins
jinking193613543jinking
kicking133314023kicking
kidskins1243453kidskins
kinins104014583ki_nins
kinking113615153kinking
kins85747903___kins
kipping163311873kipping
kipskin1243473kipskin_
lapins84520683lap_ins
leptins92412693leptins
licking144118283licking
lickings15298143lickings
lignins84010493lignins
likens105613703li_kens
liking114319583li_king
likings12539413li_kings
limpkin1534223limpkin_
linins65922143li_nins
linking123818253linking
lipids94310923lip_ids
lipin75518893lip_in_
lipoids1038233lipoids
lippens11328533lippens
lipping123016073lipping
lippings13296093lippings
lupins84514463lup_ins
malkins133311803malkins
miking134218463mi_king
milking143712763milking
minikins14208323minikins
mirins83918903mi_rins
nankins1159053nankins
napkin1236903napkin_
niacins938543niacins
nicking143516323nicking
nipping123412873nipping
oilskins1243873oilskins
oinking123714713oinking
opsins8411713_opsins
orpins83614163orp_ins
packing164420723packing
packings174310063packings
paiking143814813paiking
pains75138283__pains
papain10313793papain_
paphians1545593paphians
pappies103214823pappies
parking143423043parking
parkings153610683parkings
patins87528783p_atins
paulins9312613paulins
pavins114919663p_avins
peaking144317693peaking
pecking164017783pecking
pectins112315233pectins
peeking144414953peeking
peins76128063__peins
pekans121710553p_ekans
pekin111514423p_ekin_
pepino10310333pep_ino
pepinos1137693pep_inos
pepping113511623pepping
pepsin10310853pepsin_
pepsine11310603pepsine
pepsines1239883pepsines
peptics132610243peptics
peptids12239323peptids
perking143716463perking
phytins15317893phytins
pians75126963pi__ans
pickers153718093pickers
pickets154314183pickets
pickier153912973pickier
pickiest162712593pickiest
pickiness1737623pickiness
pickles153215443pickles
pickling17239203pickling
picks135226143pick__s
pickups1754253pickups
picnics13297343picnics
picolins1239853picolins
pidgin10259813pidgin_
piecing12410453piecing
piecings1345343piecings
pieing93917653pi_eing
pieties9419223pieties
pigeons1039183pigeons
piggies113813483piggies
piggin103111093piggin_
pigging123614673pigging
pigmies122610993pigmies
pigpens1235503pigpens
pigskin1444353pigskin_
piing85218833pi__ing
pikas114218093pi_k_as
pikers124717393pi_kers
pikes115031033pi_k_es
piki106520563pi_ki__
piling95025593pi_ling
pilings103313613pi_lings
pilis75825203pi_li_s
pilling103722563pilling
pillions101610923pillions
pimping143812123pimping
pinging113419553pinging
pining93726533pi_ning
pinions93413603pinions
pinken124513283pinken_
pinkers134118603pinkers
pinkeys16378213pinkeys
pinkie124414273pinki_e
pinkish16279113pinkish
pinkoes135512313pinkoes
pinkos125313873pink_os
pinks115729383pink__s
pinnies93318443pinnies
pinning103417853pinning
pinons86019943pi_nons
pinpoint1248993pinpoint
pinpoints1344153pinpoints
pins65558453__p_ins
pinyin112710613pinyin_
pinyons12299003pinyons
pions75826393pi__ons
pipages1289423pipages
pipals104213643pip_als
pipeline12149503pipeline
pipelines13178353pipelines
piperine122011833piperine
piperines131610693piperines
pipers104318663pip_ers
pipes96030143pip__es
pipets105714773pip_ets
pipier104913983pip_ier
pipiest113114493pip_iest
pipiness1238003pip_iness
pipit95224873pip_i_t
pips85837133pip___s
piquing1935873piquing
pirns76020093pi__rns
piscina1177043piscina
piscinas1275483piscinas
piscine11610973piscine
pishing134314373pishing
pissing103914803pissing
pistils93314303pistils
pistons93016373pistons
pithing134014053pithing
pities83828083pi_ties
pitmans11188743pitmans
pitons85319043pi_tons
pitting103618873pitting
pittings11349123pittings
pitying132910243pitying
pixies154915513pi_xies
plains85019593p_lains
plinking153611243plinking
pliskies1475973pliskies
pocking163916763pocking
pokies125921333p_okies
poking133819303p_oking
popguns1234023popguns
poplin10413483poplin_
poppies102816193poppies
popping113715413popping
popsies112816463popsies
porkies133416493porkies
porking143515813porking
postins93721203postins
pricking173212603pricking
prickings18315653prickings
prinking153212453prinking
pterins9812993pterins
puffins15278913puffins
puking133913063p_uking
pumpkin1743523pumpkin_
punkies134216803punkies
punkin123611523punkin_
pupils10389913pup_ils
puppies103212613puppies
pupping114412503pupping
purins83722653p_urins
purlins93415423purlins
pyins105815863__pyins
repins84924313rep_ins
ricins83618703ri_cins
ricking143920233ricking
ripens85012173rip_ens
riping93821613rip_ing
ripping123315743ripping
risking123914243risking
sickens134411483sickens
sickies133717503sickies
sicking143720173sicking
silkies113715693silkies
silking123715593silking
simlins9311843simlins
sinking123320543sinking
siphons1239353siphons
siping94220633sip_ing
sipping123117433sipping
siskin1079783siskin_
skins94723463__skins
spiking144312883spi_king
spilikins1543543spilikins
spins75327983_sp_ins
takins105117403_takins
ticking143218753ticking
tickings15368583tickings
tiepins939463tiepins
tiffins13327983tiffins
tikis95615973ti_ki_s
tipis76019923tip_i_s
tipping122814973tipping
unpins82312383unp_ins
viking143414613vi_king
vikings15386623vi_kings
violins10311453violins
virgins1137863virgins
welkins1437173welkins
wicking173414773wicking
wickings18357183wickings
winking153317963winking
wiping123916713wip_ing
withins133511693withins
yippies14279293yippies
yipping152710683yipping
zipping212910573zipping

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.1561145455.1
2DLD Change Limit1340273127.81317154.4
3Display Results3123120.2161444.4
 (SQL Overall)1786913128.18521831.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.