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

209 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
pelisses104848(None) 
pelisse967061pelisse_
plisses94411771p_lisses
bekisses1434242bekisses
blisses94911512_blisses
metisses1036832metisses
pavisses13397102pavisses
peises84125042pe_i_ses
pelites93821992peli_tes
pelvises1337272pelvises
penises9318192peni_ses
perishes13313752perishes
pisses84525082p__isses
plisse8368402p_lisse_
plusses93510692p_lusses
polishes13711782polishes
premisses13288762premisses
prisses94816712p_risses
relishes11311952relishes
speisses10245692spe_isses
aegises8311373aegi_ses
aliases7914493_aliases
bekissed1543163bekissed
belies84631053beli__es
believes13449403believes
betises94816123beti_ses
blesses93812393_blesses
blissed10388373_blissed
brisses94314313_brisses
celestes10310013celestes
cerises94722253ceri_ses
cesses84221363ce__sses
classes94717943_classes
coulisses1145633coulisses
cuisses9319883_cuisses
declasses1246443declasses
degasses10278363degasses
dehisces1464713dehisces
delimes10314193deli_mes
delisted10310563delisted
delists84414173deli_sts
delouses9310013delouses
demises103719563demi_ses
devisees12358283devisees
devises114116763devi_ses
disses75225963__disses
eclipses1244213eclipses
egises7312493_egi_ses
elapses957663_elapses
elides74420693_eli_des
elites66027123_eli_tes
ellipses1044343ellipses
enisles72312603_enisles
esses56422973_e__sses
eyasses10388023_eyasses
felines104718073feli_nes
felsites1138073felsites
fesses94820253fe__sses
fetishes1437153fetishes
flosses103411973_flosses
geniuses935933geniuses
glasses84414273_glasses
glosses84014123_glosses
gneisses933673gneisses
heliasts1136103heliasts
helices12313723heli_ces
helixes1739133heli_xes
hisses94719353__hisses
idlesses936003idlesses
jesses135215953je__sses
kisses104217333__kisses
kumisses1443583kumisses
lasses64827593__lasses
lewises1039133lewi_ses
lisles63416283__lisles
losses65925233__losses
megasses11307743megasses
meioses9310833me_ioses
melismas1245713melismas
merises93421423meri_ses
messes84924343me__sses
metisse936503metisse_
misses85130873__misses
molasses1037233molasses
nesses64718323ne__sses
obelises1039103obeli_ses
palisades1245613palisades
palliasses1283583palliasses
palsies94420273pal_sies
parises94827183pari_ses
parishes13314753parishes
passes86030473p__asses
pavises125315493pavi_ses
pavisse12546813pavisse_
peases85229473pe__ases
pectases122411193pectases
pedicles1338683pedicles
peeresses1138463peeresses
peise75825773pe_i_se_
peised94817683pe_i_sed
pelages10714613pel_ages
peles75738083pel___es
pelicans1238093pelicans
pelite84323003peli_te_
pellicles1344923pellicles
peloruses1145873peloruses
peltasts1035703peltasts
peltless10267373peltless
peltries10313023peltries
pelves114514663pel__ves
penalises11912763penali_ses
penlites10312263penli_tes
pensees9311203pe_nsees
pentoses10312893pentoses
peploses1269463peploses
pepluses1287013pepluses
pepsines1239883pepsines
percusses1346503percusses
perfuses1358663perfuses
periapses1346053periapses
perigees1189493perigees
periques1937653periques
perished14310073perished
perlites10316353perli_tes
perses85428063pe__rses
persists1049183persists
pertusses1145383pertusses
peruses94018163pe_ruses
petasoses1145443petasoses
petasuses1144373petasuses
petioles10311643petioles
petites93820203peti_tes
pishes114722103p__ishes
pissed94816933p__issed
pisser84416383p__isser
pissers95014753p__issers
pistes85325633p__istes
plashes124417393p_lashes
pleases94515483p_leases
pleiades1145753pleiades
plenishes1487083plenishes
plexuses1734113plexuses
plies74526513p_li__es
pliskies1475973p_liskies
pluses83618073p_l_uses
plushes124313673p_lushes
poetesses1137233poetesses
poetises10313953poeti_ses
poises84226543p_oi_ses
polices113118053poli_ces
policies122415663policies
polies84034583poli__es
polished1468433polished
polisher1388073polisher
polishers1477603polishers
politesses1245363politesses
polities102722343polities
posses85128803p__osses
praises94121103prai_ses
preblesses1445103preblesses
precesses13310463precesses
precises123218333preci_ses
prelives13310383preli_ves
premises123018273premi_ses
prerinses1138813prerinses
presses93523153p_resses
previses133814283previ_ses
prises84133173p_ri_ses
prissed103311263p_rissed
prissies101712003p_rissies
prosses94019513p_rosses
psiloses1036443psiloses
publishes1645933publishes
puisnes937423p_uisnes
pulses83818663pul__ses
punishes1338113punishes
pusses84322843p__usses
pyelitises1544853pyelitises
realises82420183reali_ses
recesses10312323recesses
reglosses1045343reglosses
reissues845993re_issues
relapses1038033relapses
releases8313343releases
relies65036423reli__es
relieves114210393relieves
relines75331323reli_nes
reliques1736903reliques
relished1239433relished
relisted9312623relisted
relists73817053reli_sts
relives104619443reli_ves
remises93423483remi_ses
repasses101810373repasses
rerises73525883reri_ses
revises104220533revi_ses
seises64026713se_i_ses
semioses10611013semioses
semises93916553semi_ses
sisses64520603__sisses
speises93813933spe_i_ses
swisses10417143_swisses
teleses7313123tel_eses
teniases838623teniases
valises103516263vali_ses
velites103417303veli_tes
welshes13379093wel_shes
wisses94619603__wisses
yesses93615813ye__sses

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 Filter1786911461620.1701051123.5
2DLD Change Limit1461622097.09620597.8
3Display Results2092090.0932247.3
 (SQL Overall)1786912097.35924282.0
 
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.