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

401 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
limpets1132978(None) 
limpers113815221limpers
limpest113712311limpest
limpet103518631limpet_
gimlets10338432gimlets
impels10389522_impels
impetus1144892_impetus
jimpest18297552jimpest
lampers113817332lampers
lappets11329132lappets
limbers113614742limbers
limens84618032lim_ens
limes75636502lim_e_s
limeys11429272lim_eys
limiest93716102limiest
limites92915452limites
limits82514142lim_its
limmers113413082limmers
limners93311562limners
limpas105513082limp_as
limped114817122limpe_d
limper104117852limpe_r
limpness1246702limpness
limps95522672limp__s
linnets739832linnets
lippens11328532lippens
lippers113416442lippers
lispers94514322lispers
lumpens11298262lumpens
lumpers113514482lumpers
pipets105714772pi_pets
simpers113014122simpers
sippets113310182sippets
tippets11339372tippets
aiglets84012913aiglets
aigrets82810533aigrets
aimers84621913aim_ers
aimless93610813aimless
aliments10311093aliments
alipeds10386793ali_peds
armets84918353arm_ets
armlets94610063armlets
armpits1157133armpits
bidets95215533bi_dets
billets94516153billets
bipeds11458053bi_peds
blimps12588153blimp__s
bumpers133912053bumpers
camlets114314623camlets
campers134220293campers
carpets113915333carpets
civets115212543ci_vets
clampers143211893clampers
climates12311973climates
climbers14318413climbers
climes104720003clim_e_s
clippers14368843clippers
comets105823583com_ets
compels133210893compels
compete134716553compete
competes144117243competes
compts125216653comp_ts
crimpers14318933crimpers
crumpets14335943crumpets
dampens12348563dampens
dampers123915693dampers
dampest12411043dampest
diapers104713913diapers
diets66026643di__ets
dimers94321093dim_ers
dimes85833043dim_e_s
dimmers123811563dimmers
dimmest1249253dimmest
dimness1038843dimness
dimouts1037893dimouts
dimples122813213dimples
dimwits1344513dimwits
dipnets10109033dipnets
dippers123615183dippers
dispels10310503dispels
dumpers123412663dumpers
emmets10349153_emmets
fidgets12388763fidgets
filets94718953fi_lets
fillets103414753fillets
filmsets1353413filmsets
flippers15338003flippers
flippest1535183flippest
fumets114311813fum_ets
gibbets12417723gibbets
giblets103210423giblets
giglets93211553giglets
gimels938893gim_els
gimlet93716663gimlet_
gimmes113010903gimme_s
gimped123911473gimpe_d
gimpiest1338483gimpiest
gimps105915203gimp__s
gippers123212083gippers
glimes94717523glim_e_s
glimmers13396153glimmers
glimpsers1442193glimpsers
glimpses1343953glimpses
guimpes1245073guimpe_s
hamlets123211403hamlets
hampers143616953hampers
hippest14219763hippest
humpers142713523humpers
imarets9138643_imarets
imbeds11456743_imbeds
impacts13266503_impacts
imparts11298533_imparts
imped105117983_impe_d
impede11469623_impede
impedes124310093_impedes
impel95711773_impe_l
impend11478793_impend
impends12376803_impends
imphees1436693_imphees
impiety1445093_impiety
impis96213853_imp_is
imports11309623_imports
impost103011783_impost
imposts11269003_imposts
impress1137773_impress
imprest11310203_imprest
imprests1246313_imprests
imps86221123_imp__s
impute1038043_impute
imputes1138083_imputes
inlets63915573_inlets
inputs837703_inputs
insets64016133_insets
islets64513083_islets
jimper17389863jimpe_r
jumpers18399843jumpers
kippers153211433kippers
kismets13306883kismets
labrets939363labrets
lambers113817113lambers
lamberts12348793lamberts
lameds94812033lam_eds
laments94314853laments
lames75445543lam_e_s
lamest84722763lam_est
lampads12477623lampads
lampas106615953lamp_as
lamped114017543lampe_d
lampreys1542883lampreys
lamps95624833lamp__s
lancets93411163lancets
lapels83712043l_apels
lappers113717463lappers
lappet103817733lappet_
leapers93716663leapers
leets54927123l__eets
lepers84817323l_epers
lets47147943l___ets
lianes63819323liane_s
libbers113812833libbers
libels85112693li_bels
libers84721443li_bers
lichees123512783lichees
lichens123510683lichens
liches114724293liche_s
lichts113712383li_chts
lickers134118253lickers
lidless8309273lidless
liefest1038443liefest
lieges74113443liege_s
liens56525503li__ens
liers55130403li__ers
lies46454193li__e_s
lieus56218483li__eus
lievest1048343lievest
lifers95617843li_fers
lifters104313783lifters
lifts85719063li__fts
ligates82318383ligates
ligers75022043li_gers
lights104519913li_ghts
likens105613703li_kens
likers104620913li_kers
likes96231903li_ke_s
likest104914383li_kest
lilies63021413lilie_s
lilts55822803li__lts
limans84816303lim_ans
limas75627633lim__as
limbas105313203lim_bas
limbate1139213limbate
limbeck1744173limbeck
limbecks1843353limbecks
limbed114513183limbe_d
limber104316793limbe_r
limbiest12258893limbiest
limbless12246313limbless
limbos104712143lim_bos
limbs96118943lim__bs
limbus105710383lim_bus
lime66244933lim_e__
limed85426803lim_e_d
limeless10249663limeless
limen75426033lim_e_n
limey104721043lim_e_y
limier83518723limie_r
liminess10510643liminess
limit73126343lim_it_
limited102310233limited
limiteds11184543limiteds
limiter92710853limiter
limiters10249333limiters
limmer104314793limme_r
limned94811473limne_d
limner84112873limne_r
limnetic1255583limnetic
limns75718393lim__ns
limos75320813lim__os
limp88432493limp___
limpa97014463limp__a
limpid11389753limp_id
limping124614113limping
limpkin1534223limpkin
limpkins1644233limpkins
limply133810033limp_ly
limpsey14365093limpsey
limpsiest1344803limpsiest
limpsy13516843limp_sy
limulus935083limulus
lindens839413lindens
linens64818393li_nens
liners65428853li_ners
lines57054573li_ne_s
lingers84223303lingers
liniest73321153liniest
linkers114317713linkers
linnet6419423linnet_
linseys1035083linseys
lintels73311163lintels
linters73822633linters
lints57137193li__nts
lioness739103lioness
lipe66839733li_pe__
lipids94310923li_pids
lipins85016883li_pins
lipless9259553lipless
lipped114419543lippe_d
lippen103911403lippe_n
lipper104219633lippe_r
lippiest122310623lippiest
lips67141443li_p__s
lisles63416283lisle_s
lisped94113423lispe_d
lisper84114433lispe_r
lisps76913913lisp__s
listees73416673listees
listels74212433listels
listens74014133listens
listers74026533listers
lists56628693li__sts
liters65429883li_ters
lithest10513913lithest
litotes7311183litotes
litres65220393litre_s
lits46252493li___ts
litters73422573litters
livens94314893li_vens
livers94927823li_vers
lives86133193li_ve_s
livest95315733li_vest
liviers104211073liviers
livres94311863livre_s
livyers13365903livyers
lockets134612203lockets
loggets9378913loggets
loments93413473loments
loopers93914033loopers
lopers84424143l_opers
lopes76437343l_ope_s
loppers113014103loppers
loupes84918053loupe_s
lumbers113815913lumbers
lumens85013973lum_ens
lumped114216963lumpe_d
lumpen104010663lumpe_n
lumper103816653lumpe_r
lumpiest1239263lumpiest
lumps95624983lump__s
lunets66914763l_unets
lymphs1635053lymp_hs
mammets103911113mammets
meets74224613__meets
midgets113910253midgets
millets94216843millets
mimeos104511543mim_eos
mimers105520183mim_ers
mimes95732023mim_e_s
minuets9259853minuets
mismeets12297733mismeets
mispens11311073mispens
missets94516573missets
moppets13307163moppets
mumpers133311373mumpers
nidgets9358143nidgets
nimiety1244633nimiety
nippers113012623nippers
nymphets1862703nymphets
pampers133615933pampers
pets66248333___pets
pickets154314183pickets
piglets103311793piglets
pigpens1235503pigpens
pimped134913483pimpe_d
pimples133012423pimples
pimps114616983pimp__s
piolets93513193piolets
pipers104318663pi_pers
pipes96030143pi_pe_s
pipet95533323pi_pet_
pipits104713063pi_pits
piquets1836603piquets
plummets14304773plummets
plumpens14304953plumpens
plumpers14357293plumpers
plumpest14236353plumpest
poppets10338853poppets
pumpers133113673pumpers
puppets10317013puppets
ramets83517393ram_ets
ramjets1635163ramjets
remeets93712413remeets
riblets93412553riblets
rickets134915093rickets
rillets74216153rillets
rimers84522553rim_ers
rimes75634543rim_e_s
rimiest93215853rimiest
rimless9369363rimless
rimmers113812883rimmers
rimples113114223rimples
ripens85012173ri_pens
ripes75435773ri_pe_s
ripest84317943ri_pest
rippers114115033rippers
ripplets12316733ripplets
rivets94417113ri_vets
rompers113412243rompers
samlets93813553samlets
signets83311503signets
simmers113314613simmers
simnels976103simnels
simper103616293simpe_r
simples113014943simples
simplest122310223simplest
simps94719763simp__s
sipes76036953si_pe_s
sippers113117753sippers
sippet103519393sippet_
skippets16284563skippets
slimes84722043slim_e_s
slimiest10310753slimiest
slimmers12369633slimmers
slimmest1235903slimmest
slimness1036523slimness
slipes84921413sli_pe_s
slippers123711233slippers
snippets12225623snippets
tampers113516743tampers
tappets113610013tappets
tempehs14325153tempehs
tempers113513013tempers
tempest1139223tempest
tempests1234443tempests
templets12226143templets
tempts10439453temp_ts
tickets134113683tickets
timbers113111853timbers
timers84420993tim_ers
times75630823tim_e_s
tippers113414353tippers
tippet103917873tippet_
trippets12357423trippets
trumpets12315573trumpets
vampers143111623vampers
violets102210003violets
vipers114914533vi_pers
whimpers18276613whimpers
whippets18255253whippets
wickets164010943wickets
widgets12318453widgets
wiglets113411423wiglets
willets104414323willets
wimped144211513wimpe_d
wimpiest1538763wimpiest
wimples143311173wimples
wimps125213803wimp__s
wipers115416083wi_pers
wipes104827083wi_pe_s
yipes106017843yi_pe_s
zibets1737743zi_bets
zippers203310383zippers

Search took 8 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 Limit1340274016.62620227.4
3Display Results4014010.1562570.5
 (SQL Overall)1786914017.18824859.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.