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

122 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
pollack156733(None) 
pollacks1656371pollacks
pollock1546841pollock
plack135017842p__lack
pollard103511142pollard
pollocks1656472pollocks
potlach14106362potlach
potluck1544032potluck
pullback1844242pullback
rollback1644882rollback
rollick1335612rollick
alack114820063__alack
black134719073__black
bollard103210503bollard
bollocks1636503bollocks
bullace113410673bullace
bullock1537193bullock
callback1845333callback
calpack17338333calpack
clack134720173__clack
coalsack1643973coalsack
collage102813763collage
collar83816173colla_r
collard103712923collard
collars93816573collars
collate92919683collate
collect113314593collect
cossack1545823cossack
cowlick1835263cowlick
dollar74110983dolla_r
dollars83311023dollars
fallacy1536433fallacy
fallback1944553fallback
flack144519413__flack
fullback1943853fullback
hillock1646693hillock
hogback1945453hogback
holdback2044513holdback
holla84918493holla__
hollaed11359853hollaed
holland11349473holland
hollas94616903holla_s
hopsack1845273hopsack
killick1295313killick
killock1255253killock
kolacky1543203ko_lacky
lack105837683___lack
mollah11319453molla_h
mollahs12328283mollahs
mollusk13103123mollusk
mullock1535713mullock
nonblack1644303nonblack
noplace1137393noplace
olla44821173_olla__
ollas54218283_olla_s
oomiack1544223oomiack
pack125535443p___ack
padlock1665813padlock
palace104516913p_alace
payback2056453payback
pillage103412603pillage
pillar8314023pilla_r
pillars9313493pillars
place94824613p__lace
placks144414153p__lacks
plank115221143p__lank
pleach134211243p_leach
plowback2143303plowback
pluck134212303p__luck
poach124917863po__ach
poblano1145093poblano
pock126129293po___ck
polar75623453po_la_r
polars84419353po_lars
poleax1547993polea_x
poleaxe1656303poleaxe
polecat11313143polecat
police102918563po_lice
policy133211513po_licy
politick16289333politick
polka11310413polka__
polkaed1435323polkaed
polkas1239103polka_s
poll66332133poll___
pollards11299523pollards
polled94022003poll_ed
pollee83623273poll_ee
pollees93215333pollees
pollen83416453poll_en
pollens93713303pollens
poller83921853poll_er
pollers93420023pollers
pollex153711163poll_ex
pollical1247953pollical
pollices12410753pollices
polling102920383polling
pollist9816603pollist
polls74627723poll__s
pollute937383pollute
pomace123111913po_mace
poplar103611113popla_r
poplars113910333poplars
populace14256253populace
potlache15114283potlache
potlatch1543133potlatch
potlucks1643303potlucks
poulard10299733poulard
prelacy1437583prelacy
prepack1757643prepack
pullbacks1943773pullbacks
rollbacks1744643rollbacks
rollicks1444893rollicks
rollicky1742693rollicky
rowlock1654783rowlock
shellack1745083shellack
slack115021763__slack
solace83415823so_lace
tollage82610163tollage
tomback17227743tomback
towsack1644723towsack
woolpack1942823woolpack
woolsack1742973woolsack

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 Filter1786911340270.406440125.6
2DLD Change Limit1340271226.84319586.0
3Display Results1221220.0462652.2
 (SQL Overall)1786911227.29524495.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.