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

178 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
papular1129976(None) 
pabular11259471pabular
papula103011111papula_
papulae11249351papulae
popular11319561popular
alular6311352_alular
canular9310322canular
capsular1245402capsular
copular113810602copular
cupular11317622cupular
fabular12288692fabular
facular122810442facular
hamular1236972hamular
macular113011942macular
papillar1296712papillar
papule102212132papul_e
papules112411572papules
piacular1246572piacular
pilular938202pilular
planular1044752planular
poplar103611112pop_lar
pupilar11125312pupilar
radular837832radular
ranular739432ranular
scapular1245372scapular
spatular1044652spatular
tabular9279762tabular
alar46340073_a__lar
alula5317093_alula_
alulae6312743_alulae
ampullar1253133ampullar
angular838533angular
annular737693annular
appear10379343_appear
appulse1134673appulse
ashlar9338193_ashlar
aurar54420253_a_urar
bacula103112673bacula_
basilar937303basilar
bipolar1145453bipolar
cannular1046283cannular
canula8312963canula_
canulae9311183canulae
canulas9312853canulas
capelan1139003capelan
capitular1343773capitular
copula102812043copula_
copulae112810613copulae
copulas113811563copulas
cupula10328433cupula_
cupulae11347853cupulae
dipolar1056853dipolar
facula112912233facula_
faculae123210353faculae
fibular12267973fibular
granular946893granular
gular6314833__gular
hauler95015123ha_uler
insular7138703insular
jaguar1435283jagu_ar
jocular1637303jocular
jugular1534513jugular
lacunar9136293lacunar
ligular8348533ligular
lobular936663lobular
locular938953locular
lunular736013lunular
macula103013673macula_
maculae113412863maculae
maculas113114023maculas
malar76424443ma__lar
manipular1344223manipular
mauler84416713ma_uler
modular1087363modular
morular978223morular
mutular936643mutular
nebular956483nebular
nodular876703nodular
ocular8610133_ocular
oracular1047533oracular
oscular937933oscular
ovular946833_ovular
pabulum1344473pabulum
paddler113711553paddler
paella8410913paella_
paellas9411413paellas
paillard1146263paillard
paler75436933pa__ler
palikar1335453palikar
pallor8313673pa_llor
palmar104113463pa_lmar
paludal1035683paludal
papa85827143pap__a_
papadam1486913papadam
papal95820673pap__al
papally1437973papally
papas94927493pap__as
papaw125112493pap__aw
papaya1337503papaya_
papayan1445303papayan
papayas1437273papayas
paper95128663pap__er
paperer113111903paperer
paphian1437453paphian
papilla11127913papilla
papillae12137023papillae
papillary1694403papillary
pappier103511603pappier
papulose1244533papulose
papyral1445773papyral
parlay113713993pa_rlay
parlor8312673pa_rlor
parura8310583parura_
paruras9310533paruras
patamar1147093patamar
patellar1046863patellar
paulin8312983pa_ulin
pauper103511943pa_uper
pausal81511963pa_usal
pauser84415963pa_user
payola11208113payola_
payolas12148973payolas
peculiar1245453peculiar
pedlar93311273p_edlar
pendular1144943pendular
pepla9312863pep_la_
phylar14437373p_hylar
pilar75221503__pilar
pillar8314023p_illar
pinnular1044433pinnular
planula935773planula_
planulae1044793planulae
plumular1243303plumular
polar75623453__polar
poplars113910333pop_lars
populace14256253populace
popularly1663843popularly
populate122812093populate
poulard10299733p_oulard
pula65129373__pula_
puler74826623__puler
pulsar8329363__pulsar
pupilary15104123pupilary
pustular1045153pustular
radula749313radula_
radulae837963radulae
radulas839583radulas
ranula6311813ranula_
ranulas7311773ranulas
regular838423regular
saccular1246893saccular
scapula1136343scapula_
scapulae1255433scapulae
scapulars1343873scapulars
scapulary1643203scapulary
scapulas1246133scapulas
secular92211533secular
simular938673simular
spatula935893spatula_
spatulas1045473spatulas
specular12217613specular
spicular12238903spicular
sporular1065223sporular
stipular1045843stipular
talar56225383ta__lar
tegular836603tegular
titular737523titular
tubular9267473tubular
tumular9236543tumular
undular837123undular
ungular836773ungular
unpopular1352313unpopular
uvular955563_uvular
vacuolar1353483vacuolar
valvular1443463valvular
vascular1346293vascular
venular1037683venular
zonular1656493zonular

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.453394461.4
2DLD Change Limit1340271787.29618369.9
3Display Results1781780.0632825.4
 (SQL Overall)1786911787.81222873.9
 
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.