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

149 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
pollened115778(None) 
colleted113011662colleted
hollered1237602hollered
palleted1139872palleted
pelleted1138202pelleted
polled94022002poll__ed
pollee83623272polle_e_
pollees93215332polle_es
pollen83416452pollen__
pollenated1345012pollenated
pollens93713302pollen_s
polluted1135432polluted
polyene1259362polyene_
polyenes13510062polyenes
volleyed1543532volleyed
aliened81011743_aliened
alleged9389323_alleged
billeted1137643billeted
bolled94722653boll__ed
bollixed1834483bollixed
bolloxed1834473bolloxed
bulleted1138393bulleted
collaged12279973collaged
collared113211143collared
collated113615063collated
collected1447973collected
colleen939543colle_en
colleens1036843colleens
college102410443college_
colleger11227933colleger
colleges112410523colleges
collided12309803collided
collied103316683coll_ied
colluded12296463colluded
cologned1237153cologned
columned1334923columned
convened143412223convened
cozened19349183co_zened
dolled83518073doll__ed
dollied93811143doll_ied
dolloped1234983dolloped
dovened12389063do_vened
dozened18377453do_zened
filleted1236603filleted
followed15146273followed
fullered1236383fullered
galleted1038223galleted
goldener1045403goldener
hoidened1335653hoidened
hollaed11359853holl_aed
holland11349473hollan_d
holloaed12157393holloaed
holloed113812753holl_oed
hollooed12146493hollooed
hollowed15157033hollowed
hoydened1644643hoydened
jollied15349273joll_ied
lolled74315823loll__ed
lolloped1134463lolloped
loosened945453loosened
loudened1044693loudened
mildened1235773mildened
milleped1335173milleped
moldered1237173moldered
omened93711003_o_mened
opened94311863_o_pened
palled94625163pall__ed
paltered113012493paltered
parleyed1436243parleyed
pattened11299393pattened
peened94318163p__eened
peltered112510453peltered
pilfered1435853pilfered
pillaged12298093pillaged
pillared11228093pillared
pilled94222753pill__ed
pillowed14156383pillowed
pilsener1044753pilsener
pinkened1535753pinkened
plained103812233p_lained
planed94420913p__laned
planned103810153p_lanned
pocketed17147143pocketed
poisoned1136953poisoned
poleaxed1854823poleaxed
poled84934843po_l__ed
polenta9310093po_lenta
policed123212233po_liced
polished1468433polished
polkaed1435323po_lkaed
pollard103511143poll_ard
pollarded1344703pollarded
pollenate1157143pollenate
pollenates1246743pollenates
pollening1236923pollening
pollenizer2144583pollenizer
pollenoses12144813pollenoses
poller83921853poll__er
pollers93420023polle_rs
pollex153711163poll__ex
pollices12410753pollices
pollinated1345823pollinated
polling102920383pollin_g
pollinia1046803pollinia
pollinic1247333pollinic
pollinized2245643pollinized
pollster1037103pollster
pollute937383pollute_
polluter1035403polluter
pollutes1037613pollutes
polyenic1547673polyenic
polygene1456693polygene_
polygenes1557503polygenes
polyped1537173po_lyped
polypnea1544253polypnea
polytene1367603polytene_
pommeled1543103pommeled
pondered126411293pondered
pooled94619813pool__ed
popeyed1535713po_peyed
portend103411193porten_d
portended1345643portended
portered112311543portered
pothered142311043pothered
potline91015233potline_
potlines10714213potlines
pottered112311663pottered
powdered15256893powdered
powered132911643po_wered
preened103214993p_reened
pulled94322193pull__ed
rolled74220243roll__ed
soddened1144643soddened
softened1235663softened
soldered1038153soldered
solleret8512223solleret
sullener857243sullener
tillered937443tillered
toileted936993toileted
tokened1236393to_kened
tolled73819033toll__ed
toluene736463toluene_
toluenes836763toluenes
trolleyed1342473trolleyed
valleyed1534013valleyed
volleyer1443163volleyer
volplaned1542733volplaned
walleyed1534153walleyed
worsened1236053worsened

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.420425454.8
2DLD Change Limit1461621497.12620511.1
3Display Results1491490.0602483.3
 (SQL Overall)1786911497.60623493.4
 
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.