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

310 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
pidgins1125912(None) 
pidgin10259811pidgin_
piggins113010471piggins
biggins113410692biggins
fidging133910502fidging
piggies113813482piggies
piggin103111092piggin_
pigging123614672pigging
pinging113419552pinging
pipkins15328182pipkins
pippins10319752pippins
ridgils9326572ridgils
ridging104112982ridging
smidgins12314842smidgins
virgins1137862virgins
aiblins9311473aiblins
aiding84423613aid_ing
aldrins8310203aldrins
algins74816433_algins
amidins103713103amid_ins
avidins11349003avid_ins
badging123712793badging
beduins1039123beduins
begins94415303_begins
biddies113514493biddies
bidding123613513bidding
biddings13397563biddings
biding104720793bid_ing
bidis86721143bid_i_s
biffins15358533biffins
biggies113813523biggies
biggin103710603biggin_
bigging122815883bigging
biggings13327473biggings
bilging114212683bilging
binging113619383binging
biogens1038963biogens
biotins93114453biotins
bodkins1438313bodkins
bridging13288443bridging
bridgings14254293bridgings
budgies115312513budgies
budging124313023budging
cadging123610973cadging
citrins92614363citrins
codeins103715483codeins
codlins104116243codlins
diamins10312213diamins
diazins1739183diazins
didies84621833did_ies
digging113513703digging
diggings12316623diggings
digits84114533di_gits
dingies93618243dingies
dinging103618613dinging
dins56652043__d_ins
dioxins1568003dioxins
disdains1037913disdains
djins1368453__djins
dodging11299063dodging
edging93510713_edging
edgings10256243_edgings
endrins8312163endrins
epigons1048183epi_gons
fadeins1168503fadeins
fadging134210243fadging
fagins10513863_fagins
fibrins1238633fibrins
ficins113513983fi_cins
fidges114114393fidg_es
fidgets12388763fidgets
figging133313563figging
firkins1437663firkins
fizgigs2142203fizgigs
fudging133310013fudging
giddies103713363giddies
gigging93311773gigging
gins55543953___gins
hedging13348953hedging
hiding114319333hid_ing
hidings12349703hid_ings
hinging123917123hinging
hoddins12289373hoddins
idling8912883_idling
igging93212073_igging
iodins74216523_iodins
jigging173011553jigging
judging17337933judging
kedging14357563kedging
kiddies133412283kiddies
kidding14389773kidding
kidskins1243453kidskins
kidvids1643113kidvids
kinging133115033kinging
kingpins1544903kingpins
kinins104014583ki_nins
leggins9259473leggins
lidding103611433lidding
ligans76817733li_gans
lignins84010493lignins
linins65922143li_nins
lipins85016883li_pins
lodging103110813lodging
lodgings11336243lodgings
logins77820643_logins
margins103815193margins
midairs1037203midairs
middens11379383middens
middies113116153middies
midges103516483midg_es
midgets113910253midgets
midguts11296013midguts
midis85923413mid_i_s
midline102315103midline
midlines112613333midlines
midribs1235513midribs
mirins83918903mi_rins
muggins11248073muggins
niacins938543niacins
nidgets9358143nidgets
niding83217983nid_ing
noggins9288453noggins
nudging10328693nudging
oodlins83210513oodlins
ordains879653ordains
origins8310463origins
paddies113715723paddies
padding123412513padding
paddings13297013paddings
padis86227143pad_i_s
pagans95717923p_agans
paging104020403p_aging
pagings114411063p_agings
pains75138283p__ains
pangens103112063pangens
panging113319113panging
papains11312363papains
parging113318603parging
pargings123410163pargings
patins87528783p_atins
paulins9312613paulins
pavins114919663p_avins
pectins112315233pectins
pegging122811133pegging
peins76128063p__eins
pekins121812233p_ekins
penguins1145383penguins
pepsins11310433pepsins
phytins15317893phytins
pians75126963pi__ans
picking163418333picking
pickings17359383pickings
picnics13297343picnics
picolins1239853picolins
piddles114314273piddles
piddling13208953piddling
pidginize2242763pidginize
pidginizes2342893pidginizes
piecing12410453piecing
piecings1345343piecings
pieing93917653pi_eing
pieties9419223pieties
pigeons1039183pigeons
piggie103210773piggi_e
piggier113510003piggier
piggiest12259663piggiest
pigginess1375453pigginess
piggish14227703piggish
pigmies122610993pigmies
pignus937953pi_gnus
pigpens1235503pigpens
pigs76634223pi_g__s
pigskins1544253pigskins
piing85218833pi__ing
piking133719643pi_king
pikis115116393pi_ki_s
pilgrims1344143pilgrims
piling95025593pi_ling
pilings103313613pi_lings
pilis75825203pi_li_s
pilling103722563pilling
pillions101610923pillions
pimping143812123pimping
pindling122110983pindling
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
pledging13276363pledging
podding124113183podding
podgier11338723podgier
podgiest12269093podgiest
podgily1435213podgily
pogies94123543p_ogies
pongids11347413pongids
ponging113416153ponging
popguns1234023popguns
poplins11313153poplins
porgies103017003porgies
postins93721203postins
priding113317543prid_ing
prigging13299093prigging
pterins9812993pterins
pudding124010803pudding
puddings13325503puddings
pudgier11377723pudgier
pudgiest12297893pudgiest
pudgily1434903pudgily
pudginess1374733pudginess
puffins15278913puffins
pugging122912543pugging
punkins133111113punkins
purging113314183purging
purgings12347293purgings
purins83722653p_urins
purlins93415423purlins
pyins105815863p__yins
reagins84215643reagins
redfins1139923redfins
ricins83618703ri_cins
ridding103314193ridding
ridgels9348023ridgels
ridges85817013ridg_es
ridgier937883ridgier
ridgiest1038903ridgiest
ridgil8316823ridgi_l
ridgling11258203ridgling
ridglings12214183ridglings
riding84325963rid_ing
ridings93412093rid_ings
rigging103016333rigging
riggings11327133riggings
ringing93521283ringing
siding83822133sid_ing
sidings94011463sid_ings
sidling9915423sidling
sieging92613203sieging
sigils73912363si_gils
signs65516323si_g_ns
simlins9311843simlins
singing93221423singing
siskins1159583siskins
smidgens12325643smidgens
smidgin11335103smidgin_
spongins1136563spongins
tidbits1035183tidbits
tidies74721833tid_ies
tiding83520093tid_ing
tidings93810263tid_ings
tidying1238513tidying
tiepins939463tiepins
tiffins13327983tiffins
tigons74112263ti_gons
tinging93619463tinging
vigias104110893vi_gias
vigils104210193vi_gils
violins10311453violins
virgin1038083virgin_
wedgies123910213wedgies
wedging13308723wedging
widdies123514033widdies
widens106212723wid_ens
widgeons1343853widgeons
widgets12318453widgets
wigans104511703wi_gans
wigging133413833wigging
wiggings14316173wiggings
winging123718713winging
withins133511693withins
yogins105114103_yogins
zigging193210533zigging
zinging183513943zinging

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.406440125.6
2DLD Change Limit1340273105.90622693.4
3Display Results3103100.1262460.3
 (SQL Overall)1786913106.43827755.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.