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

210 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
peasant931492(None) 
peasants1038261peasants
pheasant1347081pheasant
pleasant1048321pleasant
jessant1438442jessant
paesan85114092paesan_
paesani9348682paesani
paesano9338792paesano
paesans93312692paesans
passant9813942passant
peasantry1442882peasantry
peasen84815962peasen_
peccant13311732peccant
pedant9319492pe_dant
pendant10314852pendant
pennant9312492pennant
persalt9315412persalt
pheasants1443722pheasants
pissant91012502pissant
pulsant9310562pulsant
sealant73118302sealant
seawant103613412seawant
versant10313832versant
weasand1135502weasand
adamant101110443adamant
alant55742293__alant
asana5315483__asana
askant10412713__askant
aslant6317753__aslant
avant86224663__avant
basalt83519583_basalt
beast76338643beas__t
bezant17814543be_zant
bezzant1746893bezzant
blatant9310673blatant
brisant9312683brisant
ceasing104118263ceasing
clamant11312433clamant
decant93524223de_cant
defiant11311923defiant
desalt7518313de_salt
desand84812633de_sand
descant104315593descant
deviant11311313deviant
easing74926463_easing
east46659103_eas__t
eluant6315093_eluant
emanant9411093emanant
errant6618733_errant
extant132714753_extant
feasance1345823feasance
feasing113916653feasing
feast85932723feas__t
gelant72821673ge_lant
gellant83214053gellant
leant56737783le__ant
learnt64019253lea_rnt
leasing83920163leasing
least56134883leas__t
levant9314493le_vant
meant76537213me__ant
mediant103516703mediant
messan83912063messan_
messans92710463messans
natant6318733_natant
obeisant1046093obeisant
operant9317223ope_rant
paean77222723p_aean_
paeans85118263p_aeans
paesanos10296703paesanos
pagan86121163p_agan_
pagans95717923p_agans
pageant10312783pageant
paint75443693p_a_int
paisan84417073paisan_
paisana94010223paisana
paisano9429513paisano
paisans93614753paisans
pant66061263p___ant
parang93715513p_arang
parasang1147333parasang
parent83230423p_arent
past65959013p_as__t
patent84524923p_atent
pavan106518473p_avan_
pavane114113443p_avane
pavans115715593p_avans
peacing124117073peacing
peacoat11412913peacoat
peahen113410133peahen_
peahens12307573peahens
peaking144317693peaking
pealing104123203pealing
pean66147173pe__an_
peans75437643pe__ans
peanut8318183pea_nut
peart76440753pe__art
peas65755063peas___
peascod1244073peascod
pease75231113peas__e
peases85229473peas_es
peat65967933pe__a_t
pecan91919033pe_can_
pecans101515833pe_cans
pechan13511543pechan_
pechans14810503pechans
pedants10310113pe_dants
peising103416763peising
pekan111613973pe_kan_
pekans121710553pe_kans
peltast9310513peltast
penang92511113pe_nang
penchant1549583penchant
pendants1139093pendants
pendent10314723pendent
penman10312323penman_
pennants1037063pennants
pent66559073pe___nt
pentane9415743pentane
pepsin10310853pepsin_
pepsine11310603pepsine
pepsins11310433pepsins
percent113520603percent
perianth1348553perianth
periapt11313413periapt
permeant12310913permeant
perpent112318813perpent
persalts1038193persalts
persist9315853persist
person83517873person_
persona92812453persona
persons93717013persons
pesade9311103pe_sade
pessary1246873pessary
pest65555293pe_s__t
petsai838083petsa_i
petsais938433petsais
petulant1048793petulant
phalanx1945203phalanx
phasing133211673phasing
piasaba1144193piasaba
piasava1243883piasava
pieplant1268733pieplant
piquant1848003piquant
pissants1097363pissants
plaint85323203pla_int
plant75437113p__lant
platan83913693platan_
platane93112303platane
platans93413123platans
playact1446553playact
pleasance1344303pleasance
pleasanter1242423pleasanter
pleasantly1552733pleasantly
pleasantry1551633pleasantry
pleasing112611593pleasing
pliant83918823p_liant
preadapt1346863preadapt
pregnant1149883pregnant
preplant12712913preplant
present94022733present
ptisan8417973ptisan_
ptisans9317363ptisans
puissant10105393puissant
pursuant1046563pursuant
reactant10311433reactant
readapt1039743readapt
reagent8716603reagent
reascent10411983reascent
reason62616333reason_
reasons72514943reasons
reboant9315093reboant
recant83228683re_cant
recusant1049463recusant
regnant8312843regnant
regrant8317323regrant
relaxant1545843relaxant
reliant7319243reliant
remnant9312643remnant
replant93318533replant
reptant92817073reptant
resat55139683re_sa_t
resent63833623re_sent
savant9416043_savant
sealants82610743sealants
seaman84015903seaman_
season62714903season_
seasons72614233seasons
seawan94111223seawan_
seawans10379943seawans
seawants11337973seawants
secant84023293se_cant
sejant133114483se_jant
sejeant1489723sejeant
servant10313633servant
sextant142911963sextant
statant7313123statant
teacart91113193teacart
teasing83918513teasing
tenant6322473te_nant
unpleasant1252413unpleasant
vacant11415133_vacant
verdant11313293verdant
versants1137783versants
weasands1244563weasands
weason93210823weason_
weasons102310583weasons
weazand2043613weazand
wessand1144833wessand
yeast85327943yeas__t

Search took 8 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 Filter1786911340270.406440125.6
2DLD Change Limit1340272107.17318684.9
3Display Results2102100.1561346.2
 (SQL Overall)1786912107.73523101.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.