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

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

145 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
peasants103826(None) 
peasant9314921peasant_
pheasants1443721pheasants
paesanos10296702paesanos
paesans93312692paesan_s
peasantry1442882peasantry
pedants10310112pe_dants
pendants1139092pendants
pennants1037062pennants
persalts1038192persalts
pheasant1347082pheasant_
pissants1097362pissants
pleasant1048322pleasant_
sealants82610742sealants
seawants11337972seawants
versants1137782versants
weasands1244562weasands
adamants1186343adamants
alants67722023__alants
asanas6514113__asanas
basalts9358963_basalts
beasts84519723beas__ts
bezants1877343be_zants
bezzants1843643bezzants
decants103514443de_cants
desalts839573de_salts
desands94810163de_sands
descants112910143descants
deviants1236733deviants
easts57530323_eas__ts
eluants737583_eluants
errants7410623_errants
feasance1345813feasance
feasances1445403feasances
feasts95116093feas__ts
gelants82611443ge_lants
gellants9308283gellants
jessant1438443jessant_
leasings9379833leasings
leasts64616413leas__ts
levants1037723le_vants
mediants11299493mediants
messans92710463messan_s
operants1039483ope_rants
paeans85118263p_aean_s
paesan85114093paesan__
paesani9348683paesan_i
paesano9338793paesan_o
pagans95717923p_agan_s
pageants1136693pageants
paints85921833p_a_ints
paisanas10288873paisanas
paisanos10337553paisanos
paisans93614753paisan_s
pants76536923p___ants
parangs104314373p_arangs
parasangs1246033parasangs
parents93418123p_arents
passant9813943passant_
pasts75936503p_as__ts
patents94815203p_atents
pavanes123612653p_avanes
pavans115715593p_avan_s
peacoats1247833peacoats
peahens12307573peahen_s
peans75437643pe__an_s
peanuts936993pea_nuts
peasantries1353413peasantries
peascods1344063peascods
peasen84815953peasen__
peases85229473peas__es
peats76140193pe__a_ts
pecans101515833pe_can_s
peccant13311733peccant_
pechans14810503pechan_s
pedant9319493pe_dant_
pekans121710553pe_kan_s
peltasts1035703peltasts
penangs10268373pe_nangs
penchants1646193penchants
pendant10314853pendant_
pendents1139413pendents
pennant9312493pennant_
pentanes10316073pentanes
pepsines1239883pepsines
pepsins11310433pepsin_s
percents122713363percents
perianth1348553perianth
perianths1445473perianths
periapts1237273periapts
perpents122312033perpents
persalt9315413persalt_
persists1049183persists
personas102511873personas
persons93717003person_s
pesades10310893pe_sades
pests75933273pe_s__ts
petsais938433petsa_is
piasabas1243883piasabas
piasavas1343333piasavas
pieplants1355433pieplants
pissant91012503pissant_
plaints94012053pla_ints
plants84921803p__lants
platanes102711883platanes
platans93413123platan_s
playacts1543813playacts
pleasance1344293pleasance
pleasances1444193pleasances
pleasanter1242423pleasanter
pleasantest1352833pleasantest
pleasantly1552733pleasantly
pleasantry1551633pleasantry
preadapts1444003preadapts
presents103315633presents
ptisans9317363ptisan_s
pulsant9310563pulsant_
reactants1146623reactants
readapts1145583readapts
reagents959623reagents
reascents1177393reascents
reasons72514943reason_s
recants93217093re_cants
recusants1145103recusants
regrants9310013regrants
relaxants1643243relaxants
remnants1036843remnants
replants102811243replants
resents74221223re_sents
savants1038653_savants
sealant73118303sealant_
seasons72614233season_s
seawans10379943seawan_s
seawant103613413seawant_
secants93413893se_cants
servants1137993servants
sextants15287383sextants
teacarts10116073teacarts
tenants7311013te_nants
versant10313833versant_
weasand1135503weasan_d
weasons102310583weason_s
weazands2143333weazands
wessands1243673wessands
yeasts96413053yeas__ts

Search took 9 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 Filter1786911461620.1561145455.1
2DLD Change Limit1461621457.82618676.5
3Display Results1451450.0632301.6
 (SQL Overall)1786911458.04522211.4
 
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.