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

151 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
peace9502608(None) 
pace86345771p_ace
peaced115818911peaced
peaces106324081peaces
peach125422491peach
peage84723561peage
pease75231111pease
pence94924451pence
place94824611place
ace59656832__ace
apace94718382apace
beach124623892beach
brace95629272brace
cease75227652cease
dace76934922_dace
deave95022332deave
deface123113862deface
deice84320032deice
deuce84517492deuce
each95530582_each
ease45042332_ease
eave75733582_eave
epact94921532epact
face96140122_face
fease84824872fease
feaze175216312feaze
fence105319912fence
glace87420152glace
grace85124542grace
heave114521812heave
hence104920042hence
lace66848472_lace
leach105422522leach
lease55230262lease
leave84723722leave
mace87345792_mace
menace103216942menace
pac79054082p_ac_
paca85132242p_aca
paced106931682p_aced
pacer96131612p_acer
paces96741112p_aces
pacey126720282p_acey
pack125535442p_ack
pacs85842182p_acs
pact86648722p_act
pacy115328682p_acy
page76036102p_age
palace104516912palace
pale66055012p_ale
pane64950292p_ane
pare66760842p_are
pase65346862p_ase
pate65350462p_ate
pave96133892p_ave
pea56657242pea__
peached154315882peached
peacher144216072peacher
peaches144120052peaches
peachy164510842peachy
peag75431342pea_g
peages94321842peages
peags86122842peags
peahen113410132peahen
peak106535202pea_k
peaked136117402peaked
peaks114825622peaks
peaky145718152peaky
peal68648102pea_l
pealed95322802pealed
peals75235492peals
pean66147172pea_n
peans75437642peans
pear69745232pea_r
pearl75324462pearl
pears75138612pears
peart76440752peart
peas65755062pea_s
peasen84815962peasen
peases85229472peases
peat65967932pea_t
peats76140192peats
peaty105725692peaty
peavey14398792peavey
peavy135014842peavy
pec76744412pe_c_
pecan91919032pecan
pech116125452pe_ch
peck125730682pe_ck
pecs84634102pe_cs
pedate93117762pedate
pee56066512pe__e
peeve104915252peeve
peise75825772peise
peke105926202pe_ke
pekoe114612362pekoe
pelage9515362pelage
pele65539552pe_le
penance11313442penance
pencel103812912pencel
penne75423852penne
perch124518832perch
pere66450262pe_re
perse75429522perse
pesade9311102pesade
pewee10319972pewee
phage115113672phage
phase104617212phase
pice84641092p_ice
piece96717992piece
pierce104010392pierce
placed114318002placed
placer105117742placer
places104323702places
placet103923672placet
plack135017842plack
plage84520402plage
plaice10311552plaice
plane74929142plane
plate74635112plate
pleach134211242pleach
please84315732please
poach124917862poach
pomace123111912pomace
ponce95222512ponce
prance104318572prance
prase76128752prase
prate75135982prate
preach133613922preach
preact103220392preact
preface14510922preface
prerace11414122prerace
price93725412price
puce85127882p_uce
race66746262_race
reach105123882reach
react74634332react
reave84528022reave
recce9514562recce
reface113616352reface
relace83122152relace
seance83716682seance
space95325672space
spence103813792spence
tace65342512_tace
teach105221122teach
tease55428712tease
tenace82715692tenace
terce75721842terce
trace75829612trace
weave115218532weave

Search took 3 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.1731032896.0
2DLD Change Limit538001511.84329191.5
3Display Results1511510.0334575.8
 (SQL Overall)1786911512.04987208.9
 
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.