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

383 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
promises12291676(None) 
premises123018271premises
promines123018801promines
promise113415841promise_
promised133010871promised
promisee122711331promisee
promisees13246861promisees
promiser122510671promiser
promisers13268201promisers
atomises103514402atomises
bromides13219362bromides
bromines122514252bromines
bromisms1436402bromisms
bromizes21258332bromizes
poises84226542p_o_ises
praises94121102pr_aises
praxises1739062praxises
precises123218332precises
premies113823062premi_es
premise113818552premise_
premised133013192premised
premiss113513812premis_s
premisses13288762premisses
premixes193110082premixes
previses133814282previses
primines123013702primines
primuses1237082primuses
prises84133172pr__ises
proclises1339542proclises
profiles133211232profiles
prolines102619692prolines
promine112819442promine_
promisor12266182promisor
promisors13236352promisors
promotes12314122promotes
propines122618932propines
proposes122515972proposes
proses84733472pro__ses
prosses94019512pro_sses
prossies101515222prossies
protases102115032protases
protists10313352protists
provides1439882provides
provisoes1446652provisoes
provisos1336912provisos
proxies163014932proxi_es
pyrosises1457582pyrosises
remises93423482_remises
adonises92611433adonises
agonises92613163agonises
anomies93316993anomi_es
aphorises14310003aphorises
apomixes1934853apomixes
arises65233803ar__ises
armies85123693ar_mi_es
armoires1057623armoires
arouses74921293aro_uses
arrises71617583ar_rises
atomies93918363atomi_es
atomise93013823atomise_
atomised11278833atomised
atomiser10268153atomiser
atomisers11255453atomisers
atomisms12269573atomisms
atomists102610953atomists
atomizes192711423atomizes
azotises1737603azotises
braises93818873br_aises
brewises1337213brewises
brises84927613br__ises
bromates12413133bromates
bromes104719763brom__es
bromide12269583bromide_
bromids12278603bromi_ds
bromine112915243bromine_
bromins112513783bromi_ns
bromism1337623bromis_m
bromize20238823bromize_
bromized22215893bromized
broses86524403bro__ses
browses124712693bro_wses
bruises93212913br_uises
camises114218463_camises
chamises153513313chamises
chemises153211983chemises
chromides1747603chromides
chromites16310963chromites
chromizes2547603chromizes
compromises1954183compromises
creolises1157893creolises
crises84529433cr__ises
crocuses1239023crocuses
cronies9622503croni_es
crosses94220793cro_sses
cruises93514443cr_uises
demises103719563_demises
dermises112512023dermises
domines102918973_domines
dropsies1138693dropsies
drosses84513823dro_sses
drowses114610233dro_wses
ebonises1039223ebonises
enosises8311003enosises
epitomises1445313epitomises
eremites10312593eremites
ermines9416663er_mines
eroses65327053ero__ses
erotisms10310163erotisms
erotizes17311213erotizes
fomites123613203_fomites
fraises104215693fr_aises
frises94124273fr__ises
fromages1437073fromages
gnomists1145473gnomists
grosses84517683gro_sses
grouses84616543gro_uses
hoises94823673_ho_ises
homies114524723_homi_es
homines123518643_homines
idolises938763idolises
improvises1784593improvises
iodises83413633_iodises
ionises72916433_ionises
irises64221173ir__ises
iritises839973iritises
ironies7517423ironi_es
ironists839293ironists
ironizes17510373ironizes
itemises1087693itemises
kermises14248313kermises
koumises1444593koumises
krises105016083kr__ises
lionises8310313lionises
lorises73918593_lorises
mises74740563___mises
momisms10308223_momisms
momuses1159263_momuses
morrises10711063morrises
mortises10713603mortises
noises65021853_no_ises
nomisms11268743_nomisms
optimises1346073optimises
orchises1338773orchises
oroides8311973oro_ides
orrises71312233or_rises
outpromises1552253outpromises
ozonises1776373ozonises
palmists12268813palmists
panmixes1934913panmixes
paradises122513193paradises
parises94827183p_arises
parodies11313693parodi_es
parodists1248513parodists
parvises133911913parvises
pastises103616053pastises
patronises1298433patronises
pavises125315493p_avises
peises84125043p__eises
pelvises1337273pelvises
penises9318193p_enises
peonies93620153peoni_es
peonisms1238443peonisms
peroxides1947473peroxides
phimoses1537193phimoses
phonies123717513phoni_es
phthises1645713phthises
pigmies122610993pigmi_es
pirogies1139423pirogi_es
pismires1235883pismires
plosives1335893plosives
podites103014733p_odites
poesies93217403p_oesies
poetises10313953poetises
pogies94123543p_ogi_es
pogromists1543613pogromists
poise75127893p_o_ise_
poised94918473p_o_ised
poiser84217243p_o_iser
poisers94214433p_o_isers
pokies125921333p_oki_es
polices113118053p_olices
polies84034583p_oli_es
polishes13711783p_olishes
pomaces132712123p_omaces
pomades123711733p_omades
pomes94833933p_om__es
pommies133712843p_ommies
ponies84833463p_oni_es
popsies112816463p_opsies
porgies103017003porgi_es
porisms113713453p_orisms
porkies133416493porki_es
porpoises1348433porpoises
poses74642763p_o__ses
posies84431433p_osi_es
posses85128803p_o_sses
potsies93019483p_otsies
practises1349623practises
praise84419413pr_aise_
praised104214813pr_aised
praiser93413943pr_aiser
praisers103410833pr_aisers
pralines102217723pralines
prases84429023pr__ases
precipes143212213precipes
precise113518173precise_
precised133213413precised
preciser123411663preciser
precisest13259003precisest
preemies12512193preemi_es
prefiles133113443prefiles
prefires134313283prefires
prefixes20389233prefixes
prelives13310383prelives
premie103617993premi_e_
premier113515633premi_er
premieres13288233premieres
premiers122911653premiers
premiums1437533premiums
premixed20338003premixed
prerinses1138813prerinses
presides11414913presides
presses93523153pr_esses
previse123713793previse_
prevised143611073prevised
prewires133811013prewires
prexies163415003prexi_es
prices104524543pr__ices
prides94324183pr__ides
pries74339533pr__i_es
primages13159273primages
primates121515933primates
primes104225263pr__imes
primine113214823primine_
primings13338133primings
primness1276763primness
primroses1344843primroses
primsie1137543primsie_
priories10312453priori_es
prise74632613pr__ise_
prised94322203pr__ised
prisms104915503pr__isms
priss74623893pr__is_s
prisses94816713pr_isses
prissies101712003prissies
privies122414263privi_es
prizes173819813pr__izes
probates12414263probates
probes104119453pro__bes
probities13312653probities
probits112712573probi_ts
procaines13311513procaines
process11310403proces_s
processes13310233processes
proclisis1346773proclisis
procures1239213procures
prodigies1346953prodigies
produces1347903produces
proettes10312763proettes
profanes132311573profanes
profess1237713profes_s
professes1437873professes
profile123211153profile_
profiled14338523profiled
profiler13287643profiler
profilers14236293profilers
profited14279973profited
profiter132710203profiter
profiters14228313profiters
profits122911243profi_ts
profuse1237153profuse_
prognoses1247533prognoses
progress1137023progress
prolamines14159343prolamines
prolapses13145573prolapses
prolepses13126193prolepses
proles84627203pro__les
proline92321593proline_
prominent1349573prominent
promising14410973promising
promoed12310083prom_oed
promos105116423prom__os
promote11313143promote_
promoted13310543promoted
promoter12311453promoter
promoters13310073promoters
prompted1536903prompted
prompter1437983prompter
prompters1537533prompters
promptest1546053promptest
prompts1337473prom_pts
proms95426403prom___s
promulges1443383promulges
pronates10418373pronates
propanes122415823propanes
propenes122816513propenes
prophases16411063prophases
propine113020213propine_
propined133111503propined
propolises1448853propolises
propones122516963propones
propose112714843propose_
proposed132011073proposed
proposer121810633proposer
proposers13228523proposers
proptoses1349873proptoses
prorates10418063prorates
prosaisms1346273prosaisms
prosaists1157493prosaists
prose75835123pro__se_
prosed94921093pro__sed
proser84223463pro__ser
prosers94219643pro__sers
prosier93817483prosi_er
prosiest10416523prosiest
prosiness11311673prosiness
prosos85718553pro__sos
pross76529403pro__s_s
prossie91812953prossie_
prosties101421193prosties
protamines14149793protamines
protasis102411973protasis
proteases112110823proteases
proteges1149923proteges
proteides12238783proteides
proteoses112211013proteoses
protests10310483protests
proteuses11238993proteuses
protheses1449053protheses
protist9320223protis_t
protiums1238553protiums
protyles13249833protyles
proves114322253pro__ves
provide1339853provide_
provided1536843provided
provider1436703provider
providers1535583providers
provinces1646853provinces
provirus1345453provirus
proviruses1554513proviruses
proviso1237313provis_o
provokes1776603provokes
provosts1336083provosts
prowess1237903prowes_s
prowesses1437193prowesses
prunuses1035123prunuses
psoriases1144863psoriases
ptomaines1345533ptomaines
ptoses83514673pto__ses
pumices1338273p_umices
pygmies15205673pygmi_es
pyoses114314303pyo__ses
pyrolizes2347223pyrolizes
pyrolyses1745583pyrolyses
pyronines1458323pyronines
raises64826543_r_aises
ramies84630463_rami_es
remiges103015473_remiges
remise84221953_remise_
remised103516843_remised
remiss84216353_remis_s
remixes164313873_remixes
rerises73525883_rerises
revises104220533_revises
rises55244043_r__ises
romaines10512513_romaines
romanises11311563_romanises
roomies93017243roomi_es
rooses65526233_ro_oses
roses56445773_ro__ses
rouses65436283_ro_uses
semises93916553_semises
somites94219113_somites
sorosises947303sorosises
surmises10310643surmises
tamises92715973_tamises
trompes114111623trom_pes
tropines102214923tropines
tropisms1247723tropisms
upraises10188473upr_aises
uprises92012733upr__ises
uprouses1037553upro_uses
whosises1435333whosises

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.1701051123.5
2DLD Change Limit1461623838.59317009.4
3Display Results3833830.1562455.1
 (SQL Overall)1786913838.91920034.9
 
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.