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

156 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
pollsters113717(None) 
pollster1037101pollster_
polluters1135031polluters
bolsters103712452bo_lsters
holsters113211942ho_lsters
molesters1198872molesters
oldsters996732_oldsters
pilasters1138222pilasters
plasters103518132p_lasters
polestars1157282polestars
polishers1477602polishers
pollers93420022poll__ers
polluter1035402polluter_
pollutes1037612pollute_s
polyesters1545232polyesters
posters93928012po__sters
poulters103911052poul_ters
ballasters1245093ballasters
balloters1157673balloters
balusters1136643balusters
billeters1136873billeters
blasters104116143_blasters
blisters104015083_blisters
blusters104413893_blusters
boasters103915663bo_asters
bolster93713423bo_lster_
bolters94017803bo_l_ters
boosters104013443bo_osters
cloisters1137433cloisters
clusters102912403_clusters
clysters13227843_clysters
coasters104317333co_asters
collates103019143collate_s
collators11410343collators
collegers12256833collegers
colliders12298073colliders
colliers103613583coll_iers
colluders12285613colluders
colters93522443co_l_ters
costers94128333co__sters
coulters103614313coul_ters
delusters1035983delusters
doomsters1236173doomsters
dopesters1237283dopesters
enlisters937113enlisters
filisters1237003filisters
fillisters1343873fillisters
flusters113811503_flusters
followers15146183followers
foresters12312533foresters
fosters104220103fo__sters
glisters93912603_glisters
hoisters113513483ho_isters
hollers103818233holl__ers
holster103512213ho_lster_
hoopsters1445683hoopsters
jokesters2044443jokesters
jolliers15357433joll_iers
jolters143711993jo_l_ters
jousters153210423jo_usters
klisters123910483_klisters
lasters75627693__lasters
listers74026533__listers
lobsters10268743lo_bsters
lollers72713793loll__ers
lusters73921443__lusters
maltsters1135193maltsters
mobsters12359063mo_bsters
molester1099373molester_
molters93816973mo_l_ters
monsters103314543mo_nsters
moulters103510783moul_ters
oldster896573_oldster_
oleasters936733_oleasters
ousters74122793_o_usters
oysters103411693_o_ysters
palmisters1444673palmisters
palters94021683p_al_ters
pasters94531733p__asters
pelters93720313p_el_ters
pensters103012123p_ensters
pesters93827093p__esters
philters1398173phil_ters
piasters102912813p_iasters
pilaster1038163pilaster_
pillagers12276913pillagers
pilsners1035533p_ilsners
pinasters1136823pinasters
plaisters1137813plaisters
plaiters103512633p_laiters
planters102915323p_lanters
plashers133813453p_lashers
plaster93318693p_laster_
plastery13279703p_lastery
platers93924093p__laters
platters103415283p_latters
pleaters103613793p_leaters
plotters104011553p_lotters
pocketers17196493pocketers
poetasters1245283poetasters
pointers103013723po_inters
poisers94214433po_is_ers
polders103617373po_l_ders
polers84225643po_l__ers
polestar1047113polestar_
policers12259993po_licers
polisher1388073polisher_
polishes13711783polishe_s
politer92417073po_liter_
pollees93215333poll__ees
pollens93713303poll__ens
poller83921853poll__er_
pollices12410753pollice_s
pollists10910823pollist__s
polltakers1642403polltakers
pollute937383pollute__
polluted1135433pollute_d
polyester1445353polyester_
polymers1538333po_lymers
polywaters1874323polywaters
poofters1336923po_ofters
poolers94217423pool__ers
popliteus1353073popliteus
porters93722703po__rters
posers84223973po__s_ers
poster84129173po__ster_
postern93615613po__stern
posterns102713723po__sterns
potters94024343po__tters
poulter93712013poul_ter_
pouters94221873po__uters
powters124015663po__wters
presters103419003p_resters
protesters12169383protesters
psalters10227713psal_ters
pullers93618483pull__ers
pullovers14124243pullovers
pulsers94213153p_uls_ers
punsters103310583p_unsters
roadsters1035103roadsters
roasters83615933ro_asters
roisters83615553ro_isters
rollers73117473roll__ers
rollovers1244093rollovers
roosters83514663ro_osters
rosters73727543ro__sters
rousters84315683ro_usters
roysters113610533ro_ysters
songsters1046113songsters
toasters83912723to_asters
tollers73217463toll__ers
ulsters72711983__ulsters
upholsters1542733upholsters
volleyers1542773volleyers
zoolaters1844983zoolaters
zosters163015413zo__sters

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 Filter1786911486410.1561145455.1
2DLD Change Limit1486411567.72019254.0
3Display Results1561560.0762052.6
 (SQL Overall)1786911567.95222471.2
 
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.