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

194 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
pease7523111(None) 
cease75227651cease
ease45042331_ease
fease84824871fease
lease55230261lease
pase65346861p_ase
peace95026081peace
peage84723561peage
peas65755061peas_
peasen84815961peasen
peases85229471peases
peise75825771peise
perse75429521perse
phase104617211phase
please84315731please
prase76128751prase
tease55428711tease
abase76023482abase
appease1137912appease
base64847022_base
beast76338642beast
blase75524232blase
case65848082_case
ceased94920782ceased
ceases84427072ceases
cense75121402cense
chase105127122chase
crease85519572crease
deash95617242deash
deave95022332deave
debase94014472debase
dense65923502dense
eased65430402_eased
easel54521112_easel
eases56041612_eases
east46659102_east
easy76224492_easy
eave75733582_eave
else45923082_else
erase54925492erase
feased105718712feased
feases95422922feases
feast85932722feast
feaze175216312feaze
fesse86116332fesse
geese64316002geese
grease75416232grease
hearse94114272hearse
heave114521812heave
jesse126012832jesse
keas86337092keas_
lase46148512_lase
leas45954182leas_
leased74722882leased
leaser65322672leaser
leases65428112leases
leash85519212leash
least56134882least
leave84723722leave
lense54523432lense
lyase85512412lyase
measle83513222measle
mense75025632mense
pace86345772p_ace
page76036102p_age
paise75028332paise
pale66055012p_ale
pane64950282p_ane
pare66760842p_are
parse75236992parse
pas58775742p_as_
paseo77022512p_aseo
pases75346502p_ases
pash95638132p_ash
pass65239952p_ass
passe75525692passe
past65959012p_ast
paste74932952p_aste
pate65350462p_ate
pause75021832pause
pave96133892p_ave
pea56657242pea__
peaced115818912peaced
peaces106324082peaces
peach125422492peach
peag75431342pea_g
peages94321842peages
peags86122842peags
peahen113410132peahen
peak106535202pea_k
peaked136117402peaked
peaks114825622peaks
peaky145718152peaky
peal68648102pea_l
pealed95322802pealed
peals75235492peals
pean66147172pea_n
peans75437642peans
pear69745232pea_r
pearl75324462pearl
pears75138612pears
peart76440752peart
peat65967932pea_t
peats76140192peats
peaty105725692peaty
peavey14398792peavey
peavy135014842peavy
pecs84634102pecs_
pectase112410362pectase
pedate93117762pedate
pedes85327282pedes
peds75835242peds_
pee56066512pe__e
pees65257372pees_
peeve104915252peeve
pegs75531762pegs_
pehs95625762pehs_
peised94817682peised
peises84125042peises
peke105926202pe_ke
pekes114623562pekes
pekoe114612362pekoe
pelage9515362pelage
pele65539552pe_le
peles75738082peles
pence94924452pence
penes75839222penes
penne75423852penne
pens65649642pens_
pensee8417312pensee
peps85134512peps_
pere66450262pe_re
peres76246642peres
perses85428062perses
peruse84016842peruse
pes57259782pe_s_
pesade9311102pesade
peso66925822pe_so
pest65555292pe_st
pets66248332pets_
pewee10319972pewee
pews95731532pews_
phage115113672phage
phased124011972phased
phases114618402phases
phrase11109902phrase
pias66542552pias_
place94824612place
plage84520402plage
plane74929142plane
plash104616562plash
plasm94114632plasm
plate74635112plate
pleas75627032pleas_
pleased103712072pleased
pleaser93912342pleaser
pleases94515482pleases
poise75127892poise
pose66441732p_ose
posse74722272posse
praise84419412praise
prases84429022prases
prate75135982prate
prese75228382prese
prise74632612prise
prose75835122prose
pulse74219972pulse
purse76028892purse
pyas96225702pyas_
rase46149982_rase
reave84528022reave
reuse56025362reuse
seas45755272seas_
seise54727852seise
sense55526822sense
speise84614252speise
spense83912432spense
teas45851492teas_
teased74721152teased
teasel63914982teasel
teaser65421522teaser
teases65426272teases
tense55225842tense
terse55026822terse
ukase9428492ukase
unease63816642unease
urase54624682urase
urease64516992urease
vase75629652_vase
verse84723582verse
weasel93410522weasel
weave115218532weave
yeas78638422yeas_
yeast85327942yeast

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 Filter178691538000.186960704.3
2DLD Change Limit538001945.7509356.5
3Display Results1941940.1561243.6
 (SQL Overall)1786911946.09229332.1
 
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.