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

205 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
peases8522947(None) 
ceases84427071ceases
eases56041611_eases
feases95422921feases
leases65428111leases
pases75346501p_ases
peaces106324081peaces
peages94321851peages
pease75231111pease_
peasen84815961peasen
peises84125041peises
perses85428061perses
phases114618401phases
pleases94515481pleases
prases84429021prases
teases65426271teases
abases85720772abases
appeases1238662appeases
baases85218012baases
bases75644352_bases
beasts84519722beasts
beses75830722be_ses
biases84618432biases
cases75048382_cases
cease75227652cease_
ceased94920782ceased
censes83721802censes
cesses84221362cesses
chases115128232chases
crases85532312crases
creases94020962creases
deashes113313902deashes
deaves105319532deaves
debases103814132debases
degases93413102degases
ease45042332_ease_
eased65430402_eased
easel54521112_easel
easels65914552_easels
easies64126632_easies
easts57530322_easts
eaves85231992_eaves
eposes84418782eposes
erases64425402erases
erses55826802_erses
eses45336102_e_ses
esses56422972_esses
eyases94513682eyases
fease84824872fease_
feased105718712feased
feasts95116092feasts
feazes184514172feazes
fesses94820252fesses
gases65633992_gases
greases84816712greases
hearses104414532hearses
heaves124120302heaves
jesses135215952jesses
kvases13467102kvases
lases54944762_lases
lease55230262lease_
leased74722882leased
leaser65322672leaser
leasers74717842leasers
leashes103514402leashes
leasts64616412leasts
leaves94222382leaves
lenses64620892lenses
leses54930812le_ses
lyases95211872lyases
measles92412752measles
menses84222452menses
messes84924342messes
myases113711552myases
nesses64718322nesses
oases55330982_oases
paces96741112p_aces
pages85235072p_ages
pales75753802p_ales
panes76148692p_anes
pares77164482p_ares
parses85534702parses
pase65346862p_ase_
paseo77022512p_aseo
paseos88015812p_aseos
pashes115828392p_ashes
pass65239952p_as_s
passe75525692p_asse
passes86030472passes
pastes85233912p_astes
pasts75936502p_asts
pates76047892p_ates
pauses84621472pauses
paves104833922p_aves
paxes144928422p_axes
peace95026082peace_
peaced115818912peaced
peaches144120052peaches
peage84723572peage_
peags86122842pea_gs
peahen113410132peahen
peahens12307572peahens
peaked136117402peaked
peaks114825622pea_ks
pealed95322812pealed
peals75235492pea_ls
peans75437642pea_ns
pearls84715392pearls
pears75138612pea_rs
peas65755062pea__s
peats76140192pea_ts
peavey14398792peavey
peaveys15324062peaveys
peavies122213402peavies
pectases122411192pectases
pedes85327292pe_des
pees65257372pe__es
peeves113814872peeves
peise75825772peise_
peised94817682peised
pekes114623562pe_kes
pekoes124410422pekoes
pelages10714612pelages
peles75738082pe_les
pelves114514662pelves
penates93321602penates
penes75839222pe_nes
penises9318192penises
pensee8417312pensee
pensees9311202pensees
peones83821042peones
peres76246642pe_res
perse75429522perse_
peruses94018162peruses
pesades10310902pesades
pesos77221622pe_sos
pests75933272pe_sts
petasos948602petasos
petasus946362petasus
pewees11311392pewees
phages125213512phages
phase104617212phase_
phased124011972phased
phasis114614922phasis
phrases12711462phrases
physes14399782physes
pisses84525082pisses
places104323702places
plages94520152plages
planes85028082planes
plashes124417392plashes
plasms103711332plasms
plates85432242plates
please84315732please_
pleased103712072pleased
pleaser93912342pleaser
pleasers104010292pleasers
pluses83618072pluses
poises84226542poises
poses74642762p_oses
posses85128802posses
praises94121102praises
prase76128752prase_
prates84633162prates
praxes156215182praxes
presses93523152presses
prises84133172prises
proses84733472proses
ptoses83514672ptoses
pulses83818662pulses
purses84826372purses
puses75532202p_uses
pusses84322842pusses
pyoses114314302pyoses
rases55447212_rases
reales64934122reales
reaves94127572reaves
reuses66025522reuses
seises64026712seises
senses63923942senses
sepses84515882sepses
speises93813932speises
spenses92913572spenses
stases64225562stases
tease55428712tease_
teased74721152teased
teasel63914982teasel
teasels74311312teasels
teaser65421522teaser
teasers75317242teasers
tenses64722552tenses
texases1437572texases
ukases10358062ukases
uneases73316262uneases
upases84112902upases
urases63723562urases
ureases74416722ureases
vases84626262_vases
verses94223762verses
weasel93410522weasel
weasels10468502weasels
weaves123616372weaves
yeasts96413052yeasts
yeses85119322ye_ses
yesses93615812yesses

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 Filter178691825510.360496363.9
2DLD Change Limit825512053.39024351.3
3Display Results2052050.0633254.0
 (SQL Overall)1786912053.81346863.6
 
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.