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

101 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
panchax213498(None) 
cancha134411612cancha_
canchas143212402canchas
pacha126518062pa_cha_
pachas135017142pa_chas
panchaxes2344452panchaxes
panocha1444982panocha_
panochas1545652panochas
paschal14157242paschal
ancho104515303_anch_o
anchor113911973_anchor
anchos114214893_anchos
anthrax1757153_anthrax
banjax2234763ban_jax
barchan1469133barchan
cancan10314103canc_an
canthal12410053canthal
concha134213283concha_
conchae143911643conchae
conchal144211583conchal
conchas144013313conchas
dacha114812573da_cha_
dachas124113253da_chas
datcha1266563datcha_
datchas1347423datchas
handax1749583han_dax
manche133515103manch_e
manches143818623manches
manchet143317783manchet
nachas114914193na_chas
paca85132243pa_c_a_
pacas96029403pa_c_as
packwax2542853packwax
padshah16113353padshah
painch133511323painch__
painches1588913painches
pakeha1533933pakeha_
pakehas1635313pakehas
panacea1137783panacea_
panacean1244733panacean
panaceas1236763panaceas
panache1458423panach_e
panaches15310283panaches
panada94113053panada_
panadas103312213panadas
panama104213353panama_
panamas113112763panamas
pancake1536673pancake
pancreas1235393pancreas
panda85022613pan_da_
pandas95521963pan_das
panga85323533pan_ga_
pangas99921103pan_gas
pangram1239023pangram
panoche1456383panoch_e
panoches1548123panoches
panther12611443panther
parch125123003parch__
parched154013693parched
parches143720003parches
pascal10812373pasc_al
paschals1566473paschals
pasha105417183pa_sha_
pashas115117063pa_shas
patch125221223patch__
patched153514623patched
patcher143515143patcher
patches143320383patches
patchy16509573patch_y
paunch13369853paunch__
paunched1645523paunched
paunches1568173paunches
paunchy17324443paunch_y
paxwax1742953pa_xwax
pechan13511543p_echan
penchant1549583penchant
pickax2135913p_ickax
pinch125619303pinch__
pinched153812453pinched
pincher143812713pincher
pinches144117933pinches
planch133711443planch__
planche14299753planch_e
planches153111863planches
planchet152511963planchet
poncho133310123ponch_o
ponchos143410703ponchos
punch125118423punch__
punched153512173punched
puncher143311673puncher
punches144816133punches
punchy16398523punch_y
ranch105019793ranch__
ranched133113603ranched
rancher123013633rancher
ranches123620113ranches
ranchman1546043ranchman
rancho114310853ranch_o
ranchos123911393ranchos
sancta839833sancta_
xanthan1736013xanthan

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 Filter1786911340270.390458182.1
2DLD Change Limit1340271016.40620922.1
3Display Results1011010.0303366.7
 (SQL Overall)1786911016.82626178.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.