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 “pollacks” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

96 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
pollacks165637(None) 
pollack1567331pollack_
pollocks1656471pollocks
bollocks1636502bollocks
placks144414152p__lacks
pollards11299522pollards
pollices12410752pollices
pollock1546842pollock_
potlucks1643302potlucks
pullbacks1943772pullbacks
rollbacks1744642rollbacks
rollicks1444892rollicks
blacks144914953__blacks
bollards11339153bollards
bullaces12299433bullaces
bullocks1636293bullocks
callbacks1945023callbacks
calpacks18266523calpacks
clacks144516343__clacks
coalsacks1743513coalsacks
collages113514243collages
collards113310193collards
collars93816573colla_rs
collates103019143collates
collects12279783collects
cossacks1645223cossacks
cowlicks1944663cowlicks
dollars83311023dolla_rs
fallbacks2044353fallbacks
flacks154114533__flacks
fullbacks2043603fullbacks
hillocks1736063hillocks
hogbacks2044853hogbacks
holdbacks2144313holdbacks
hollands12247273hollands
hollas94616903holla__s
hopsacks1944733hopsacks
killicks1354873killicks
killocks1354793killocks
kolacky1543203ko_lacky
lacks116129203___lacks
mollahs12328283molla_hs
mollusks14102653mollusks
mullocks1645033mullocks
nonblacks1743923nonblacks
ollas54218283_olla__s
oomiacks1643533oomiacks
packs135528933p___acks
padlocks1755473padlocks
palaces114216453p_alaces
paybacks2145493paybacks
pillages113012613pillages
pillars9313493pilla_rs
places104323703p__laces
plack135017843p__lack_
planks124116753p__lanks
plowbacks2243123plowbacks
plucks14379733p__lucks
poblanos1244993poblanos
pocks135022963po___cks
polars84419353po_la_rs
poleaxes1767273poleaxes
polecats1248833polecats
polices113118053po_lices
politicks17276843politicks
polkas1239103polka__s
pollard103511143polla_rd
pollees93215333poll_ees
pollens93713303poll_ens
pollers93420023poll_ers
pollical1247953pollical
pollists10910823pollists
polls74627723poll___s
pollutes1037613pollutes
pomaces132712123po_maces
poplars113910333popla_rs
populaces15195713populaces
potlach14106363potlac_h
potlache15114283potlache
potlaches16115263potlaches
potluck1544033potluck_
poulards11288233poulards
prepacks1836583prepacks
pullback1844243pullback_
rollback1644883rollback_
rollick1335613rollick_
rollicky1742693rollicky
rowlocks1744353rowlocks
shellacks1844553shellacks
slacks124416533__slacks
solaces93116133so_laces
tollages92410193tollages
tombacks18216463tombacks
towsacks1744173towsacks
woolpacks2042593woolpacks
woolsacks1842953woolsacks

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 Filter1786911461620.403443402.0
2DLD Change Limit146162966.44022696.0
3Display Results96960.0303200.0
 (SQL Overall)178691966.87325999.0
 
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.