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

253 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
pulsars935891(None) 
pulsar8329361pulsar_
pulsers94213151pulsers
bursars94510892bursars
fulmars1246422fulmars
hussars10326972hussars
pillars9313482pillars
polars84419352pol_ars
pulers83820282pul_ers
pullers93618482pullers
pulpers114612282pulpers
pulsant9310562pulsant
pulsate9510232pulsate
pulsates1048812pulsates
pulsators1175372pulsators
pulser84215192pulser_
pulses83818662puls_es
pursers93916092pursers
quasars1646902quasars
tussars7359242tussars
vulgars11306532vulgars
altars64518153_altars
balsams11579013balsams
balsas86417523balsa_s
blears85116453_blears
bulbar1039583bulbar_
bulgers105215143bulgers
bulgurs10397113bulgurs
bulwark1645213bulwark
bulwarks1744133bulwarks
bursar85413253bursar_
bursary12397583bursary
bursas85318273bursa_s
busbars1138153busbars
caesars9410723caesars
calcars11312653calcars
cellars93713693cellars
clears84116563_clears
collars93816573collars
cullays12347703cullays
cullers93418843cullers
culvers12329823culvers
cursers94317153cursers
cursors93910023cursors
cussers94213393cussers
dollars83311023dollars
dulias71212743dulia_s
dullard936603dullard
dullards1045493dullards
dulses73913653duls_es
durbars1077973durbars
felspars1343163felspars
fulhams1543983fulhams
fullams1236553fullams
fullers103817373fullers
fulmar1137253fulmar_
fussers104210813fussers
guars65021043gu__ars
guisard954203guisard
guisards1043603guisards
guitars8116853guitars
gulags837543gul_ags
gular6314833gul_ar_
gulpers10299003gulpers
hulas84920883hul_a_s
hullers103616263hullers
hussar9317283hussar_
kulaks976113kul_aks
kulturs1134723kulturs
lars46956573__l_ars
lears55938733__lears
liars54723163__liars
lullers73213353lullers
lumbars11289763lumbars
lunars65012813lu_nars
malars85020683mal_ars
molars85517323mol_ars
muggars11316643muggars
mullahs12388733mullahs
mullas84215933mulla_s
mullers93217303mullers
musers84719093mu_sers
mylars114310443myl_ars
nullahs10316993nullahs
nursers74311833nursers
oculars948363ocul_ars
outsays102710403outsays
outsoars838833outsoars
outwars10912793outwars
paesans93312693paesans
paisans93614753paisans
paisas84317493paisa_s
palais8420423pal_ais
palikars1445083palikars
pallors9314343pallors
palmar104113463palmar_
palmary14338553palmary
palmers113513623palmers
palsies94420273palsies
palters94021683palters
pars67560793p___ars
parsers94118153parsers
passers94717753passers
pausers94113223pausers
pears75138613p__ears
peculiars1343453peculiars
pedlars103210213pedlars
pelters93720313pelters
pessary1246873pessary
petsais938433petsais
pilafs113511023pil_afs
pilar75221503pil_ar_
pilaus84114133pil_aus
pilaws11399433pil_aws
pilfers1238963pilfers
pillar8314023pillar_
pilsners1035533pilsners
pissers95014753pissers
pitsaws1234993pitsaws
plans75731273p_l_ans
plasms103711333p_lasms
plats75531373p_l_ats
plays106320773p_l_ays
pleads94613953p_leads
pleas75627033p_lea_s
pleats85218593p_leats
pliers84715153p_liers
plurals936913plurals
pluses83618073plus_es
plushes124313673plushes
plusses93510693plusses
plyers114912983p_lyers
poisers94214433poisers
polar75623453pol_ar_
polders103617373polders
polers84225643pol_ers
polestars1157283polestars
polkas1239103polka_s
pollard103511143pollard
pollards11299523pollards
pollers93420023pollers
poplars113910333poplars
posers84223973p_osers
poulard10299733poul_ard
poulards11288233poul_ards
poulters103911043poulters
prosers94219643prosers
psywars1533673psywars
ptisans9317363ptisans
puckers153514673puckers
puffers15349203puffers
pugmark1643463pugmark
pugmarks1742533pugmarks
puisnes937423puisnes
pujahs18404943pu_jahs
pujas145513323pu_ja_s
pula65129373pul_a__
puler74826623pul_er_
pules74538813pul__es
pulings103511323pulings
pulis74225603pul__is
puller83820813puller_
pullets94015163pullets
pulleys12399143pulleys
pullmans1253933pullmans
pulls74425053pul__ls
pullups1134233pullups
pulpal10408453pulpa_l
pulper103513273pulper_
pulpits1137243pulpits
pulpous1177013pulpous
pulps95116483pul__ps
pulques1835323pulques
puls65437563pul___s
pulsated1136853pulsated
pulsator1085693pulsator
pulsatory1474613pulsatory
pulse74219973puls__e
pulsed94013723puls_ed
pulsing103712863pulsing
pulsion938393pulsion
pulsions1037713pulsions
pumas95121563pu_ma_s
pumpers133113673pumpers
punas74826753pu_na_s
punkahs16284783punkahs
punkas123410673punka_s
punkers133714853punkers
punners94114233punners
punsters103310583punsters
punters93617033punters
pupas95219283pu_pa_s
purdahs13285483purdahs
purdas92612263purda_s
purgers104714003purgers
purrs75320433pu__rrs
purs65641043pu___rs
purser85020473purser_
purses84826373purs_es
pursuers10376523pursuers
pursues94111373pursues
puses75532203pu_s_es
pushers123814503pushers
pushes114621663pu_shes
pusleys12286233pusleys
puss64830133pu_s__s
pusses84322843pu_sses
pussies93615693pussies
putters94219183putters
quasar1536833quasar_
repulsers1144713repulsers
rulers64317093rul_ers
salsas65316133salsa_s
sansars73313913sansars
sarsars73512143sarsars
sudsers83310413sudsers
sugars7312423su_gars
suldans8299723suldans
sulfas9311563sulfa_s
sulfurs1037343sulfurs
sulkers113613343sulkers
sultans72411833sultans
talars66021683tal_ars
tolars64817923tol_ars
tsars56717103__tsars
tussahs10335113tussahs
tussar6369543tussar_
tussers74313563tussers
tussors7388763tussors
tussurs7356373tussurs
ulans54921303_ul_ans
ulcers839383_ulcers
ulnar56013983_ulnar_
ulnas55716533_ulna_s
ulsters72711983_ulsters
ultras6310183_ultras
ulvas84511503_ulva_s
unbars82113033_unbars
unsays9399543_unsays
upbears1195423upbears
upleaps1185233upleaps
uploads10266503uploads
uprears9107493uprears
uproars986453uproars
upsoars985413upsoars
uptears9106443uptears
users55817573_u_sers
uvulars1044413uvul_ars
velars93913723vel_ars
vulgar10426823vulgar_
vulvar12427963vulvar_
vulvas12388843vulva_s
yulans958673yul_ans

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.1531167915.0
2DLD Change Limit1340272535.98622390.1
3Display Results2532530.0932720.4
 (SQL Overall)1786912536.23228673.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.