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

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

83 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
patzers18421057(None) 
panzers184012011panzers
paters84935831pat_ers
patters94825191patters
patzer173111641patzer_
potzers184010541potzers
bathers124720362bathers
batters94626012batters
caters85336502cat_ers
daters74827372dat_ers
eaters65535952eat_ers
fathers133916502fathers
gaters74728642gat_ers
gathers114315072gathers
gazers164516302ga_zers
haters94930402hat_ers
hatters104221522hatters
hazers184615952ha_zers
jazzers22324762jazzers
lathers104321882lathers
mamzers20409162mamzers
maters85032392mat_ers
matters94421752matters
mazers173917092ma_zers
natters73718062natters
oaters65029792oat_ers
pacers105124542pa_cers
packers153818892packers
padders113312872padders
pagers94423252pa_gers
palmers113513622palmers
palters94021682palters
pampers133615932pampers
panders103423732panders
paniers94717332paniers
panners93621272panners
panthers13510782panthers
panzer174213232panzer_
papers105125322pa_pers
parers85530742pa_rers
parkers133816872parkers
parsers94118152parsers
partiers103514242partiers
partners102711132partners
partyers13277762partyers
passers94717752passers
pasters94531732pasters
patchers153413302patchers
patens84820862pat_ens
pater74740722pat_er_
pates76047892pat_e_s
patness92912282patness
pattens95414922pattens
patter84628262patter_
pattern93712052pattern
patterns10439942patterns
paupers114311072paupers
pausers94113222pausers
pavers115021822pa_vers
pawers114818782pa_wers
pawners124311072pawners
payers114621822pa_yers
peters86624592pet_ers
petters93722362petters
pitiers93812652pitiers
platers93924092plat_ers
platters103415282platters
pothers123818622pothers
potters94024342potters
potzer174411212potzer_
praters94921652prat_ers
prizers183911842prizers
putters94219192putters
putzes174212522putze_s
raters63936582rat_ers
ratters74422472ratters
razers154919612ra_zers
spatters103914702spatters
taters64932202tat_ers
tatters74520482tatters
waltzers2034002waltzers
waters95030632wat_ers
yatters103914622yatters

Search took 4 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 Filter1786911076710.376475242.0
2DLD Change Limit107671833.22033438.2
3Display Results83830.0302766.7
 (SQL Overall)178691833.62649280.5
 
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.