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

81 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
potlach1410636(None) 
potlache15114281potlache
potlatch1543131potlatch
poach124917862po__ach
pollack1567332pollack
potash1138272pot_ash
potlaches16115262potlaches
potluck1544032potluck
attach11118393_attach
bootlace1245403bootlace
botch126717453bot__ch
clach124617823__clach
coach125919453co__ach
detach12310413det_ach
goulash1164273goulash
hotch136214733hot__ch
isotach1244953isot_ach
loach105116363lo__ach
lotah85315853lot_a_h
mollah11319453molla_h
moloch1356483mo_loch
moolah11409193moola_h
noplace1137393noplace
notch105613323not__ch
orach105219233_o_rach
palace104516913p_alace
pataca10311193pat_aca
patch125221223pat__ch
peach125422493p__each
pitch125018413pit__ch
place94824613p__lace
plack135017843p__lack
planch133711443p__lanch
plash104616563p__lash
pleach134211243p_leach
poachy16388963po__achy
poblano1145093poblano
polar75623453po_la_r
polars84419353po_lars
police102918563po_lice
policy133211513po_licy
polish114916723po_lish
pollacks1656373pollacks
pollard103511143pollard
pollock1546843pollock
pomace123111913po_mace
pooch124815303po__och
poplar103611113popla_r
poplars113910333poplars
populace14256253populace
porch125918623po__rch
portulaca1352753portulaca
postface1566123postface
postlaunch1761293postlaunch
postrace12310543postrace
potage92715903pot_age
potato8513433pot_ato
potence11711363potence
potency1457433potency
potiche1438043pot_iche
potlatched18112453potlatched
potlatches17113323potlatches
potlike13910123potlike
potline91015233potline
potlucks1643303potlucks
potman102813573potma_n
pottage103310603pottage
pouch124617083po__uch
poulard10299733poulard
preach133613923p_reach
prelacy1437583prelacy
protract12510603protract
putsch1334933put_sch
reteach1237413reteach
roach105717003ro__ach
rotch105815933rot__ch
solace83415823so_lace
stomach1436033stomach
tach96132753__t_ach
teach105221123__teach
unteach1246143unteach

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.423422437.4
2DLD Change Limit134027817.15618729.3
3Display Results81810.0302700.0
 (SQL Overall)178691817.60923484.2
 
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.