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

282 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
poplars11391033(None) 
polars84419351po_lars
poplar103611111poplar_
collars93816572collars
dollars83311022dollars
molars85517322mo_lars
pedlars103210212pedlars
peoplers1237162peoplers
pillars9313492pillars
polar75623452po_lar_
polers84225642po_lers
pollard103511142pollard
pollards11299522pollards
pollers93420022pollers
poolers94217422poolers
poplins11313152poplins
poppas93710712poppa_s
poppers103414862poppers
popular11319562popular_
poulard10299732poulard
poulards11288232poulards
tolars64817942to_lars
appears11308953appears
ashlars10297063ashlars
boars75229603bo__ars
boilers93417063boilers
bolar75123473bo_lar_
bolas74733763bo_la_s
bollard103210503bollard
bollards11339153bollards
boppers133911923boppers
bowlers123715783bowlers
boxcars1834773boxcars
boyars115611983bo_yars
boylas113011723boyla_s
byplays1743103byplays
cellars93713693cellars
coalas87418963coala_s
coalers94419353coalers
coilers93619903coilers
colas75436773co_la_s
collar83816173collar_
collard103712923collard
collards113310193collards
colors86622373co_lors
coolers93522493coolers
copalms13367543copalms
copals105018943cop_als
copays134911273cop_ays
copers104629843cop_ers
copiers114215963copiers
coplots11511593coplots
coppers133519753coppers
coppras13327833coppras
coprahs14338153coprahs
copras103517153copra_s
copters113621283copters
copular113810603copular_
copulas113811563copula_s
costars94218013costars
cottars94412243cottars
cougars1038443cougars
couplers123311323couplers
doblas93812293dobla_s
dogears937513dogears
dollar74110983dollar_
dolors75115313do_lors
dopas85019063dop_a_s
dopers95522483dop_ers
doulas75114993doula_s
foulard11257283foulard
foulards12266463foulards
fowlers133411203fowlers
gophers1338983gophers
hoars85925553ho__ars
holard10410573ho_lard
holards1148433ho_lards
hollas94616903holla_s
hollers103818233hollers
hooplas1239203hoopla_s
hopers114222973hop_ers
hoppers143115143hoppers
howlers133312353howlers
jowars16369653jo_wars
koalas104011663koala_s
kolas94822233ko_la_s
koppas14407603koppa_s
lars46956573___lars
lollers72713793lollers
lopers84424143lop_ers
loppers113014103loppers
malars85020683_malars
medlars10259443medlars
modulars1165833modulars
moilers93615203moilers
molar75223093mo_lar_
molas75132093mo_la_s
mollahs12328283mollahs
moolahs12347383moolahs
moolas83615593moola_s
mopers104220373mop_ers
moppers133412463moppers
mortars93411523mortars
mylars114310443_mylars
nonplays1344893nonplays
nonwars10109003nonwars
nopales93812523nopales
nopals84914023nop_als
noplace1137393noplace
oars46846033_o__ars
oculars948363oculars
oglers74313183_oglers
oilers64721193_oilers
ollas54218283_olla_s
onlays9398713_onlays
opahs105411983_op_ahs
opals75718353_op_als
operas8312453_operas
ottars64112223_ottars
palais8420423p_alais
pallors9314363pallors
papas94927493pap_a_s
papaws13419113pap_aws
papers105125323pap_ers
papular11299763papular_
parlays123910453parlays
parlors9312913parlors
pars67560793__p_ars
pears75138613__pears
pedlar93311273pedlar_
pedlary13277543pedlary
pedlers103013273pedlers
peelers93615593peelers
peopler1138083peopler_
peoples11312223peopl_es
pepla9312863pepla__
peplos101211543pepl_os
peplums13145503peplums
peplus10138343pepl_us
peppers103311443peppers
phylar14437373phylar_
pilafs113511023p_ilafs
pilar75221503p_ilar_
pilaus84114133p_ilaus
pilaws11399433p_ilaws
pillar8314023pillar_
pipals104213643pip_als
pipers104318663pip_ers
plans75731273__plans
plats75531373__plats
plays106320773__plays
poblano1145093poblano
poblanos1244993poblanos
pochard1537363pochard
pochards1646853pochards
poilus82210573poil_us
poisers94214433poisers
pokers124617923po_kers
polarise10513903po_larise
polaron939843po_laron
polarons1039863po_larons
polders103617373polders
poleis86018353po_leis
poler74431793po_ler_
poles75351003po_l_es
polies84034583po_lies
polios84019723po_lios
polis74731163po_l_is
polkas1239103po_lkas
pollack1567333pollack
pollacks1656373pollacks
pollees93215333pollees
pollens93713303pollens
poller83921853poller_
polls74627723po_l_ls
polos76129913po_l_os
pols66044563po_l__s
polyps13479763po_lyps
polys105718763po_l_ys
ponders103618843ponders
poniard1037583poniard
poniards1145823poniards
pooler83819843pooler_
pools74427703pool__s
popcorn1344903popcorn
popcorns1444023popcorns
popeless1288473popeless
popery134511703pop_ery
popes95933813pop__es
popguns1234023popguns
poplin10413483popl_in
popovers1595663popovers
poppa8409893poppa__
popper93615963popper_
poppets10338853poppets
poppies102816203poppies
popples103011873popples
pops86340953pop___s
popsies112816463popsies
populace14256253populace
populaces15195713populaces
popularise1445423popularise
popularly1663843popularly
populate122812093populate
populates132710673populates
populous1245953populous
porkers134314933porkers
portals94015563portals
porters93722703porters
posers84223973po_sers
poseurs9378293poseurs
postals93716373postals
posters93928013posters
pothers123818623pothers
potlach14106363potlach
potters94024343potters
potzers184010543potzers
poularde11276573poularde
poulardes12286183poulardes
poulters103911053poulters
poultry1235383poultry
poults84613483poul_ts
pourers93513673pourers
pours74623183po__urs
pouters94221873pouters
powders134111553powders
powers113822323po_wers
powters124015663powters
preplans1249613preplans
prolans9314273prolans
propers113619033prop_ers
prowlers13328933prowlers
psywars1533673psywars
pulers83820283p_ulers
pullers93618483pullers
pulpers114612283pulpers
pulsars9358913pulsars
pupas95219283pup_a_s
pupilar11125313pupilar_
pupilary15104123pupilary
replans92814943replans
replays12399763replays
roars55622243ro__ars
rollers73117473rollers
ropers84325903rop_ers
scalars93711903scalars
shophars1646353shophars
soars54732513so__ars
sofars94712783so_fars
solans64122493so_lans
solar55927343so_lar_
sonars64818973so_nars
sopors85215203sop_ors
soucars938423soucars
sowars94318013so_wars
sowcars1236013sowcars
spars75431543_sp_ars
spears84019473_spears
splats84817303_splats
splays114910873_splays
spoilers10238633spoilers
spoolers10349363spoolers
talars66021683_talars
templars1255263templars
toilers74116263toilers
tolans64319273to_lans
tolar55524113to_lar_
tolas54532773to_la_s
tollbars1045443tollbars
tollers73217463tollers
toolbars1044743toolbars
toolers74416503toolers
topers85025323top_ers
topiary1245813topiary
topless92511123topless
toppers113914603toppers
uvulars1044413uvulars
velars93913723_velars
volar86917413vo_lar_
woolers104214023woolers
yodlers11298923yodlers
yowlers13328923yowlers

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.546327272.9
2DLD Change Limit1340272825.92022639.7
3Display Results2822820.1102563.6
 (SQL Overall)1786912826.57627173.2
 
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.