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

180 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
pollster103710(None) 
pollsters1137171pollsters
polluter1035401polluter
bolster93713422bo_lster
holster103512212ho_lster
molester1099372molester
oldster896572_oldster
pilaster1038162pilaster
plaster93318692p_laster
polestar1047112polestar
polisher1388072polisher
politer92417072po_liter
poller83921852poll__er
pollute937382pollute_
polluted1135432polluted
polluters1135032polluters
pollutes1037612pollutes
polyester1445352polyester
poster84129172po__ster
poulter93712012poul_ter
ballaster1145973ballaster
balloter1078893balloter
ballsier1036523ballsier
baluster1037053baluster
billeter1037563billeter
blaster94017303_blaster
blister94415313_blister
bluster94215313_bluster
boaster94616433bo_aster
bolsters103712443bo_lsters
bolter83920753bo_l_ter
booster94314553bo_oster
cloister1037093cloister
cluster94013323_cluster
clyster12317453_clyster
coaster94219033co_aster
collate92919683collate_
collated113615063collated
collates103019133collates
collator10310373collator
colleger11227923colleger
colleted113011653colleted
collider113410413collider
collier93618153coll_ier
colluder11276863colluder
colter84625093co_l_ter
coster84331293co__ster
coulter94115593coul_ter
deluster936903deluster
doomster1135843doomster
dopester1137253dopester
enlister847803enlister
filister1137403filister
fillister1244423fillister
fluster103913063_fluster
folksier1533533folksier
follower14137073follower
forester11313673forester
foster94322223fo__ster
glister84013343_glister
hoister103714203ho_ister
holler93520613holl__er
hollower14127393hollower
holsters113211933ho_lsters
honester1139713honester
hoopster1335543hoopster
jokester1934443jokester
jollier142911003joll_ier
jolter133513093jo_l_ter
jouster143311043jo_uster
klister113410643_klister
laster64830633__laster
lister64527253__lister
lobster9288853lo_bster
loller63315283loll__er
luster64023673__luster
maltster1035303maltster
mobster11299213mo_bster
modester1197483modester
moister94015373mo_ister
molested11178243molested
molesters1198873molesters
molter84119423mo_l_ter
monster93214593mo_nster
moulter93812423moul_ter
oldsters996733_oldsters
oleaster837263_oleaster
ouster64223733_o_uster
oyster94111703_o_yster
palleted1139863palleted
pallier94417163pall_ier
palmister1345053palmister
palter84423263p_al_ter
paster85734373p__aster
pelleted1138193pelleted
pelter83321623p_el_ter
penster92811953p_enster
pester84827593p__ester
philter12108213phil_ter
piaster93012883p_iaster
pilasters1138213pilasters
pillager11278543pillager
pilsner935343p_ilsner
pinaster1037113pinaster
plaister1068013plaister
plaiter93615393p_laiter
planter94017803p_lanter
plasher124215033p_lasher
plasters103518133p_lasters
plastery13279703p_lastery
plater84427693p__later
platter93917413p_latter
pleater93916333p_leater
plotter94113663p_lotter
plusher124010383p_lusher
pocketer16157373pocketer
poetaster1145673poetaster
pointer93814933po_inter
poiser84217243po_is_er
polder94019253po_l_der
poler74431793po_l__er
polestars1157283polestars
policer113112683po_licer
polished1468433polished
polishers1477603polishers
polishes13711783polishes
polite83625073po_lite_
polled94022003poll__ed
pollee83623273poll__ee
pollees93215333poll_ees
pollen83416453poll__en
pollened1157773pollened
pollers93420023poll__ers
pollex153711163poll__ex
pollices12410753pollices
pollist9816603pollist__
pollists10910823pollist_s
polls74627723polls___
polltaker1542723polltaker
polyesters1545233polyesters
polymer1438063po_lymer
polywater1774783polywater
poofter1237163po_ofter
pooler83819843pool__er
poplitei1245483poplitei
porter84224413po__rter
poser75128773po__s_er
posher115018163po__sher
posted93722493po__sted
postern93615603po__stern
posters93927993po__sters
potter83926983po__tter
poulters103911043poul_ters
pouter83923983po__uter
powter114116033po__wter
prester93519623p_rester
protester111510483protester
psalter9247813psal_ter
puller83820813pull__er
pullover13134643pullover
pulser84215193p_uls_er
punster92911103p_unster
roadster935453roadster
roaster74116663ro_aster
robuster1035663robuster
roister73516203ro_ister
roller63919793roll__er
rollover1144453rollover
rooster74415173ro_oster
roster64329083ro__ster
rouster73517083ro_uster
royster103110533ro_yster
songster935783songster
toaster74414463to_aster
toller63819443toll__er
ulster63712103__ulster
upholster1442683upholster
volleyer1443163volleyer
zoolater1746093zoolater
zoster153715853zo__ster

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 Filter1786911461620.1731032896.0
2DLD Change Limit1461621807.65619091.2
3Display Results1801800.0632857.1
 (SQL Overall)1786911807.89222642.0
 
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.