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

355 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
pippins1031975(None) 
pipkins15328181pipkins
pippin92810301pippin_
pipping113414741pipping
dipping134014832dipping
gipping133813122gipping
hippies142813752hippies
hipping153915102hipping
kipping163311872kipping
lipins85016882li_pins
lippens11328532lippens
lipping123016072lipping
lippings13296092lippings
nipping123412872nipping
papains11312362papains
pappies103214832pappies
pepping113511622pepping
pepsins11310432pepsins
pidgins11259122pidgins
piggins113010472piggins
pigpens1235502pigpens
pimping143812122pimping
piping114017452pi_ping
pipings12338252pi_pings
pipits104713062pi_pits
pipkin14248602pipkin_
poplins11313152poplins
poppies102816202poppies
popping113715412popping
puppies103212622puppies
pupping114412502pupping
ripping123315742ripping
sipping123117432sipping
tiepins939462tiepins
tipping122814972tipping
yippies14279292yippies
yipping152710682yipping
zipping212910572zipping
aiblins9311473aiblins
biffins15358533biffins
biggins113410693biggins
biopics13318543biopics
biotins93114453biotins
blipping15306803blipping
bopping143512033bopping
buppies133011063buppies
caplins113515993caplins
capping143819673capping
cappings15369493cappings
chippies17309763chippies
chipping18389793chipping
chopins142312243chopins
cioppino1443343cioppino
cioppinos1542203cioppinos
cipolins1238033cipolins
citrins92614363citrins
clipping15349153clipping
clippings16273753clippings
copping143918593copping
cupping144312383cupping
cuppings15336053cuppings
dapping133714793dapping
diamins10312213diamins
diapirs10347643diapirs
diazins1739183diazins
dioxins1568003dioxins
dippers123615183dippers
dippier123111393dippier
dippiest132511143dippiest
dippiness1435973dippiness
dripping14278033dripping
drippings15313903drippings
dupping133711043dupping
emptins1179403emptins
fibrins1238633fibrins
ficins113513983fi_cins
fipples14298653fipples
firkins1437663firkins
fivepins1644083fivepins
flipping16307663flipping
fopping153511133fopping
gapping134214783gapping
gimping133710763gimping
gipons9389603gi_pons
gippers123212083gippers
gipsies1039903gipsies
gripping14277543gripping
guppies123310523guppies
gypping16305843gypping
hairpins1365433hairpins
happens14359173happens
happing153817233happing
harpins123615703harpins
hatpins123410643hatpins
hipline12311423hipline
hiplines13310593hiplines
hippie132811243hippi_e
hippier143212103hippier
hippiest152611623hippiest
hippiness1635463hippiness
hippish1736183hippish
hippos13408433hipp_os
hopping154115273hopping
hoppings16306523hoppings
imping114315353_imping
impings12348553_impings
impis96213853_impi_s
iodins74216523_iodins
kepping16268593kepping
kingpins1544903kingpins
kinins104014583ki_nins
kippen14299013kippen_
kippers153211433kippers
kipskins1343263kipskins
koppies153210013koppies
lapins84520683_lapins
lapping124117023lapping
leptins92412693leptins
lignins84010493lignins
limping124614113limping
limpkins1644233limpkins
linins65922143li_nins
lipids94310923li_pids
lipin75518893li_pin_
lipoids1038233lipoids
lippen103911403lippen_
lippers113416443lippers
lippier112710573lippier
lippiest122310623lippiest
lippiness1335413lippiness
lisping103412753lisping
lopping123815223lopping
lupins84514463_lupins
mapping143413993mapping
mappings15296413mappings
mirins83918903mi_rins
mispens11311073mispens
mopping143411473mopping
napkins1336673napkins
nappies114613403nappies
napping123514183napping
niacins938543niacins
ninepins1045873ninepins
nippers113012623nippers
nippier11319833nippier
nippiest12279983nippiest
nippily1444713nippily
nippiness1334713nippiness
nipples11319663nipples
opsins8411713_opsins
orpins83614163_orpins
pains75138283__pains
palping124112873palping
papain10313793papain_
paphians1545593paphians
pappi84810893pappi__
pappier103511603pappier
pappiest112611123pappiest
pappous1057463pappous
pappus9408373papp_us
patins87528783p_atins
paulins9312613paulins
pavins114919663p_avins
pectins112315233pectins
peeping123615213peeping
peins76128063__peins
pekins121812233p_ekins
pepino10310333p_epino
pepinos1137693p_epinos
peppers103311443peppers
peppier10268323peppier
peppiest11278573peppiest
peppily1335133peppily
peppiness1235183peppiness
pepsin10310853pepsin_
pepsine11310603pepsine
pepsines1239883pepsines
peptics132610243peptics
peptids12239323peptids
phytins15317893phytins
pians75126963pi__ans
picking163418333picking
pickings17359383pickings
picnics13297343picnics
picolins1239853picolins
pidgin10259813pidgin_
piecing12410453piecing
piecings1345343piecings
pieing93917653pi_eing
pieties9419223pieties
pigeons1039183pigeons
piggies113813483piggies
piggin103111093piggin_
pigging123614673pigging
pigmies122610993pigmies
pigpen1136583pigpen_
pigskins1544253pigskins
piing85218833pi__ing
piking133719643pi_king
pikis115116393pi_ki_s
piling95025593pi_ling
pilings103313613pi_lings
pilis75825203pi_li_s
pilling103722563pilling
pillions101610923pillions
pimples133012423pimples
pimps114616983pimp__s
pinging113419553pinging
pining93726533pi_ning
pinions93413603pinions
pinkens13419643pinkens
pinkies133818263pinkies
pinking143918943pinking
pinkings15338143pinkings
pinnies93318443pinnies
pinning103417853pinning
pinons86019943pi_nons
pinpoint1248993pinpoint
pinpoints1344153pinpoints
pins65558453___pins
pinyin112710613pinyin_
pinyons12299003pinyons
pions75826393pi__ons
pipages1289423pipages
pipals104213643pi_pals
pipeline12149503pipeline
pipelines13178353pipelines
piperine122011833piperine
piperines131610693piperines
pipers104318663pi_pers
pipes96030143pi_p_es
pipets105714773pi_pets
pipier104913983pi_pier
pipiest113114503pi_piest
pipiness1238003pi_piness
pipit95224873pi_pi_t
pipped104516543pipp_ed
pips85837133pi_p__s
piquing1935873piquing
pirns76020093pi__rns
piscina1177043piscina
piscinas1275483piscinas
piscine11610973piscine
pishing134314373pishing
pissing103914803pissing
pistils93314303pistils
pistons93016373pistons
pithing134014053pithing
pities83828083pi_ties
pitmans11188743pitmans
pitons85319043pi_tons
pitting103618873pitting
pittings11349123pittings
pitying132910243pitying
pixies154915513pi_xies
plains85019593p_lains
plopping12318703plopping
pompons1338553pompons
pooping123615443pooping
popguns1234023popguns
poplin10413483poplin_
poppas93710713popp_as
poppers103414863poppers
poppets10338853poppets
poppied11388983poppied
popples103011873popples
poppling12227323poppling
popsies112816463popsies
postins93721203postins
potpies113116173potpies
preppies1149693preppies
prepping12309763prepping
primping15338893primping
propine113020213propine
propines122618933propines
propping122811673propping
pterins9812993pterins
puffins15278913puffins
pulping123612323pulping
pulpits1137243pulpits
pumping144213553pumping
pumpkins1843853pumpkins
punkins133111113punkins
pupils10389913p_upils
puppets10317013puppets
purins83722653p_urins
purlins93415423purlins
pushpins1543343pushpins
pyins105815863__pyins
quipping2234843quipping
rapping123619103rapping
rappini11347573rappini
repins84924313_repins
repping123314983repping
ricins83618703ri_cins
ripens85012173ri_pens
riping93821613ri_ping
rippers114115033rippers
ripples113513293ripples
rippling13197573rippling
sapping123519313sapping
shippens15316803shippens
shipping163611253shipping
shippings17275683shippings
shippons15255663shippons
simlins9311843simlins
siphons1239353siphons
siping94220633si_ping
sippers113117753sippers
sippets113310183sippets
siskins1159583siskins
skipping17297603skipping
slipping133510663slipping
snipping13308853snipping
sopping123917203sopping
spins75327983__spins
supping123814533supping
tapping123317133tapping
tappings13267713tappings
tenpins9410073tenpins
tiepin839343tiepin_
tiffins13327983tiffins
tipis76019923ti_pi_s
tippers113414353tippers
tippets11339373tippets
tippier113210543tippier
tippiest122310023tippiest
tipples112811253tipples
tippling13196703tippling
topping123514623topping
toppings13286423toppings
topspins1244873topspins
tripping133210923tripping
trippings14225723trippings
tropins93116313tropins
tupping123411663tupping
unpins82312383_unpins
upping114013703_upping
uppings12257123_uppings
violins10311453violins
virgins1137863virgins
wapping153514603wapping
whipping19328173whipping
whippings20284183whippings
wimping153911013wimping
wiping123916713wi_ping
wisping133711943wisping
withins133511693withins
yapping153412613yapping
yippie13277843yippi_e
yuppies14339263yuppies
zapping213211473zapping
zippers203310383zippers
zippier20308193zippier
zippiest21248103zippiest

Search took 7 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.390458182.1
2DLD Change Limit1340273556.12321889.1
3Display Results3553550.1402535.7
 (SQL Overall)1786913556.65326858.7
 
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.