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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

125 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
pechs12551620(None) 
pech116125451pech_
pecks135724431pecks
pecs84634101pec_s
pehs95625761pe_hs
techs106915831techs
yechs136112581yechs
becks135522012becks
beths105519222beths
decks124822192decks
decos85522122decos
eche97520282_eche
eches106322162_eches
echo96615952_echo
echos105216462_echos
echt95722902_echt
ecus65421462_ecus
edhs86212102_edhs
epochs1335812epochs
eths76619522_eths
feces105625362feces
fecks145417852fecks
fehs106522382fe_hs
gecks125117092gecks
hecks145220652hecks
hehs106723962he_hs
heths116317782heths
heuchs14447922heuchs
ichs96214712_ichs
kecks105416572kecks
lech96825442lech_
leches115421312leches
lochs106715512lochs
machs125722562machs
meths105320232meths
necks115119332necks
pacas96029402pacas
paces96741112paces
pacha126518062pacha
pachas135017142pachas
packs135528932packs
pacs85842182pac_s
pacts95125802pacts
paths105521382paths
peaces106324082peaces
peach125422492peach_
peaches144120052peaches
peachy164510842peachy
peags86122842peags
peaks114825622peaks
peals75235492peals
peans75437642peans
pears75138612pears
peas65755062pe_as
peats76140192peats
pec76744412pec__
pecan91919032pecan
pecans101515832pecans
pechan13511542pechan
pechans14810502pechans
peched144915342peched
peck125730682pec_k
pecky165515092pecky
pedes85327282pedes
peds75835242pe_ds
peeks115021112peeks
peels75226422peels
peens76428192peens
peeps95822362peeps
peers75130272peers
pees65257372pe_es
pegs75531762pe_gs
peh86740962pe_h_
peins76128062peins
pekes114623562pekes
peles75738082peles
pelfs105016292pelfs
pelts76128812pelts
pends85527192pends
penes75839222penes
penis75129322penis
pens65649642pe_ns
peons75327182peons
pepos96620082pepos
peps85134512pe_ps
perch124518832perch_
perches143717952perches
peres76246642peres
peris75537072peris
perks115325802perks
perms95524512perms
perps95521482perps
pervs105117372pervs
pes57259782pe__s
pesos77221622pesos
pests75933272pests
pets66248332pe_ts
pews95731532pe_ws
picas94626522picas
picks135226142picks
pics85633912pic_s
pieces104217272pieces
piths105817542piths
pocks135022962pocks
poohs103915712poohs
precis103416702precis
psychs1653652psychs
puces94924632puces
pucks134322102pucks
recks115625132recks
recs65734182rec_s
secs65033892sec_s
sects75622892sects
specks144312702specks
specs96916672spec_s
tachs105820932tachs
tech95925442tech_
techy135612012techy
teths85418512teths
wecht13415442wecht
wechts1446252wechts
yeahs115214552yeahs
yecchs16414952yecchs
yech127220532yech_
yechy16519082yechy

Search took 2 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 Filter178691538000.0931921408.6
2DLD Change Limit538001251.70331591.3
3Display Results1251250.0333787.9
 (SQL Overall)1786911251.82997698.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.