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

162 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
popular1131956(None) 
copular113810601copular
papular11299761papular
poplar103611111pop_lar
copula102812042copula_
copulae112810612copulae
copulas113811562copulas
cupular11317622cupular
jocular1637302jocular
lobular936662lobular
locular938952locular
modular1087362modular
morular978222morular
nodular876702nodular
ocular8610132_ocular
ovular946832_ovular
pabular11259472pabular
papula103011112papula_
papulae11249352papulae
pilular938202pilular
polar75623452po__lar
poplars113910332pop_lars
populace14256252populace
popularly1663842popularly
populate122812092populate
poulard10299732po_ulard
pupilar11125312pupilar
sporular1065222sporular
unpopular1352312unpopular
zonular1656492zonular
alular6311353_alular
ampullar1253133ampullar
angular838533angular
annular737693annular
anovular1144163anovular
biovular1343603biovular
bipolar1145453bipolar
bolar75123473bo__lar
canular9310323canular
capsular1245403capsular
collar83816173co_llar
consular1038813consular
copulate122614113copulate
coruler9311713coruler
cougar958783co_ugar
coupler114713013coupler
cupula10328433cupula_
cupulae11347853cupulae
dipolar1056853dipolar
dollar74110983do_llar
doula65717773do_ula_
doulas75114993do_ulas
fabular12288693fabular
facular122810443facular
fibular12267973fibular
foulard11257283fo_ulard
fouler93614903fo_uler
globular1143383globular
gular6314833__gular
hamular1236973hamular
insular7138703insular
jugular1534513jugular
ligular8348533ligular
lunular736013lunular
macular113011943macular
modulars1165833modulars
molar75223093mo__lar
morula8710473morula_
morulae958963morulae
morulas959713morulas
mutular936643mutular
nebular956483nebular
nonpolar1046283nonpolar
oculars948363_oculars
oscular937933oscular
ovulary1344913_ovulary
papillar1296713papillar
papule102212133papul_e
papules112411573papules
peculiar1245453peculiar
pedlar93311273p_edlar
pendular1144943pendular
peopler1138073peop_ler
pepla9312863pep_la_
phylar14437373p_hylar
piacular1246573piacular
pilar75221503__pilar
pillar8314023p_illar
pinnular1044433pinnular
planular1044753planular
plumular1243303plumular
polars84419353po__lars
poler74431793po__ler
pollard103511143po_llard
poller83921853po_ller
pooler83819843po_oler
poplin10413483pop_lin
popover1495843popover
poppa8409893pop_pa_
poppas93710713pop_pas
popper93615963pop_per
popple92710983poppl_e
poppled11339233poppled
popples103011873popples
populaces15195713populaces
popularise1445423popularise
popularity1754683popularity
popularize2345683popularize
populated14228803populated
populates132710673populates
populism1446073populism
populist1248203populist
populous1245953populous
postwar1236903postwar
poularde11276573po_ularde
poulards11288233po_ulards
poult76928873po_ul_t
poulter93712013po_ulter
poultry1235383po_ultry
poults84613483po_ults
pour611527473po_u__r
pourer84516043po_urer
pouter83923983po_uter
propyla14296633propyla_
pula65129373__pula_
puler74826623__puler
pulsar8329363__pulsar
pupilary15104123pupilary
pustular1045153pustular
radular837833radular
ranular739433ranular
regular838423regular
scapular1245373scapular
scopula1154993scopula_
scopulae1254613scopulae
scopulas1265483scopulas
secular92211533secular
simular938673simular
solar55927343so__lar
solunar735283solunar
soucar839323so_ucar
spatular1044653spatular
specular12217613specular
spicular12238903spicular
stipular1045843stipular
tabular9279763tabular
tegular836603tegular
titular737523titular
tolar55524113to__lar
torula6610393torula_
torulae758553torulae
torulas759853torulas
tubular9267473tubular
tumular9236543tumular
undular837123undular
ungular836773ungular
uvular955563_uvular
venular1037683venular
volar86917413vo__lar
zonula1537223zonula_
zonulae1645963zonulae
zonulas1637023zonulas

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.1561145455.1
2DLD Change Limit1340271627.59317651.4
3Display Results1621620.0632571.4
 (SQL Overall)1786911627.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.