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

127 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
pollards1129952(None) 
bollards11339151bollards
collards113310191collards
pollard103511141pollard_
poulards11288231poulards
bollard103210502bollard_
collard103712922collard_
collars93816572collar_s
dollars83311022dollar_s
dullards1045492dullards
foulards12266462foulards
goliards1045132goliards
holards1148432ho_lards
hollands12247272hollands
mallards1138322mallards
paillards1244982paillards
pillars9313492pillar_s
pochards1646852pochards
polars84419352po_lar_s
pollacks1656372pollacks
pollarded1344702pollarded
pollers93420022poller_s
poniards1145822poniards
poplars113910332poplar_s
poulard10299732poulard_
poularde11276572poularde
poulardes12286182poulardes
ballads104212913balla_ds
ballyards1544993ballyards
billiards1245023billiards
boards94616933bo__ards
bombards1536493bombards
boyards13399323bo_yards
cellars93713693cellar_s
coalyards1543533coalyards
coleads102911423colea_ds
collages113514243collages
collar83816173collar__
collared113211143collared
collaret103116703collaret
collarets11327333collarets
collates103019143collates
colloids11310173colloids
costards113510793costards
cowards1339613co_wards
dollar74110983dollar__
dotards937253do_tards
dullard936603dullard_
forwards1537043forwards
foulard11257283foulard_
galliards1194543galliards
goldarns1043593goldarns
goliard936073goliard_
halliards13104933halliards
halyards1576243halyards
hoards104912623ho__ards
holard10410573ho_lard_
hollaed11359853hollaed_
holland11349473holland_
hollas94616903holla__s
hollers103818233holler_s
lallands9338573lallands
lards65331863___lards
liards75212613__liards
lollers72713793loller_s
lowlands1244373lowlands
mallard10310273mallard_
milliards1246193milliards
molars85517323mo_lar_s
mollahs12328283molla_hs
norlands936443norlands
ollas54218283_olla__s
onwards1137173_onwards
paillard1146263paillard_
pallors9314363pallor_s
pards85634333p___ards
pedlars103210213pedlar_s
pellagras1243383pellagras
petards104311153p_etards
pilchards1743923pilchards
pillages113012613pillages
pillar8314023pillar__
pillared11228093pillared
placards1345813placards
plaids94312443p__laids
pleads94613953p_lea_ds
plowlands1542583plowlands
poblanos1244993poblanos
pochard1537363pochard_
polar75623453po_lar__
polarise10513903po_larise
polaron939843po_laron
polarons1039863po_larons
polders103617373polder_s
poleaxes1767273poleaxes
polers84225643po_ler_s
poleward1455943poleward_
polkaed1435323polkaed_
polkas1239103polka__s
pollack1567333polla_ck
pollarding1444243pollarding
polled94022003poll_ed_
pollees93215333poll_ees
pollens93713303poll_ens
poller83921853poller__
pollices12410753pollices
pollists10910823pollists
pollocks1656473pollocks
polls74627723poll___s
pollutes1037613pollutes
polybrids1745453polybrids
polypeds1645773polypeds
polypods1647113polypods
poniard1037583poniard_
poolers94217423pooler_s
poplar103611113poplar__
postcards1445733postcards
potshards1544053potshards
pullers93618483puller_s
pulsars9358913pulsar_s
rollers73117473roller_s
solands84412343so_lands
tolars64817943to_lar_s
tollages92410193tollages
tollbars1045443tollbar_s
tollers73217463toller_s
towards1138783to_wards

Search took 9 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.423422437.4
2DLD Change Limit1461621277.70318974.7
3Display Results1271270.0462760.9
 (SQL Overall)1786911278.17221866.3
 
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.