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

224 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
promised13301087(None) 
premised133013191premised
promise113415841promise_
promisee122711331promisee
promiser122510671promiser
promises122916761promises
atomised11278832atomised
bromized22215902bromized
poised94918472p_o_ised
praised104214812pr_aised
precised133213412precised
premise113818552premise_
premises123018272premises
premixed20338012premixed
prevised143611072prevised
prised94322202pr__ised
profiled14338522profiled
profited14279972profited
promine112819442promine_
promines123018802promines
promisees13246862promisees
promisers13268202promisers
promisor12266182promisor
promoed12310082prom_oed
promoted13310542promoted
prompted1536902prompted
propined133111502propined
proposed132011072proposed
prosed94921092pro__sed
provided1536842provided
remised103516842_remised
agonised10248483agonised
aphorised1546363aphorised
aroused84914343aro_used
atomise93013823atomise_
atomiser10268153atomiser
atomises103514403atomises
atomized20279323atomized
azotised1844443azotised
braised104014803br_aised
broiled103811423bro_iled
bromated1339173bromated
bromid112612893bromi__d
bromide12269583bromide_
bromides13219363bromides
bromine112915243bromine_
bromines122514253bromines
bromism1337623bromis_m
bromisms1436403bromisms
bromize20238823bromize_
bromizes21258333bromizes
browsed134511233bro_wsed
bruised10389503br_uised
chromized2645913chromized
compromised2052773compromised
creolised1255203creolised
crossed105313893cro_ssed
cruised103710213cr_uised
demised113613683_demised
dropsied1234963dropsied
drowsed12448743dro_wsed
ebonised1136043ebonised
epitomised1553283epitomised
ermined10410603er_mined
erotized1838553erotized
groined92710813gro_ined
grossed93812253gro_ssed
groused94712833gro_used
hoised105117433_ho_ised
idolised1045673idolised
improvised1873563improvised
iodised9329243_iodised
ionised82911493_ionised
irised73913153ir__ised
ironized1858203ironized
itemised11105163itemised
lionised946603lionised
mortised1178743mortised
noised75416233_no_ised
optimised1444313optimised
outpromised1651983outpromised
ozonised1853893ozonised
parodied1238333parodi_ed
patronised1395033patronised
peised94817683p__eised
peroxided2045073peroxided
phonied133710563phoni_ed
plumiped1533313plumiped
poetised1138523poetised
poise75127893p_o_ise_
poiser84217243p_o_iser
poises84226543p_o_ises
policed123212233p_oliced
polished1468433p_olished
pomaded13377863p_omaded
ponied94920703p_oni_ed
porpoised1445453porpoised
posed85828413p_o__sed
posited10511493p_osited
practised1446103practised
praise84419413pr_aise_
praiser93413943pr_aiser
praises94121103pr_aises
praxises1739063praxises
precise113518173precise_
preciser123411663preciser
precises123218333precises
precited133013813precited
prefiled143310573prefiled
prefired144310753prefired
prefixed21357703prefixed
premed114617763prem__ed
premie103617993premi_e_
premier113515633premi_er
premiered14237093premiered
premies113823063premi_es
premiss113513813premis_s
premisses13288763premisses
premixes193110083premixes
prerinsed1246323prerinsed
presided12410553presided
pressed103317313pr_essed
previse123713793previse_
previses133814283previses
prewired14358473prewired
priced115018883pr__iced
prided103618033pr__ided
pried84426863pr__i_ed
primed115118913pr__imed
primine113214823primine_
primines123013703primines
primmed14388853prim_med
primped14479153prim_ped
primsie1137543primsie_
primuses1237083primuses
prise74632613pr__ise_
prises84133173pr__ises
prissed103311263pr_issed
prized184415393pr__ized
probated13410863probated
probed114114823pro__bed
proceed12310553pro_ceed
processed1446803processed
proclises1339543proclises
procured1336603procured
prodded1257733pro_dded
produced1456073produced
profaned14207973profaned
professed1545243professed
profile123211153profile_
profiler13287643profiler
profiles133211233profiles
profiter132710203profiter
profuse1237153profuse_
progged12409803pro_gged
prognosed1344533prognosed
prolapsed14133733prolapsed
proline92321593proline_
prolines102619693prolines
prologed12189213prologed
prominent1349573prominent
promising14410973promising
promisors13236363promisors
promos105116423promos__
promote11313143promote_
promoter12311453promoter
promotes12314123promotes
prompter1437983prompter
proms95426413prom_s__
promulged1542433promulged
pronated11414053pronated
pronged113912393pro_nged
proofed13138723pro_ofed
propine113020213propine_
propines122618933propines
proponed132412033proponed
propose112714843propose_
proposer121810633proposer
proposes122515973proposes
propped113311953pro_pped
prorated11513713prorated
prose75835123pro__se_
proser84223463pro__ser
proses84733473pro__ses
prosier93817483prosi_er
prosiest10416523prosiest
prosses94019513pro_sses
prossie91812953prossie_
prossies101515223prossies
protases102115033protases
protested12159113protested
protist9320223protis_t
protists10313363protists
proved125016033pro__ved
provide1339853provide_
provider1436703provider
provides1439883provides
proviso1237313provis_o
provisoes1446653provisoes
provisos1336913provisos
provoked1875053provoked
prowled13309913pro_wled
proxies163014933proxi_es
pumiced1435173p_umiced
pyramided1873833pyramided
pyrolized2446123pyrolized
pyrosises1457583pyrosises
raised76120333_r_aised
remise84221953_remise_
remises93423483_remises
remixed173510743_remixed
revised113815483_revised
roiled74320053_ro_iled
romanised1247923_romanised
romped114513653_rom_ped
roosed75621593_ro_osed
rosed65930343_ro__sed
rosined84911903_rosined
roused75426443_ro_used
surmised1136863surmised
tromped124210293trom_ped
upraised11167413upr_aised
uproused1135833upro_used
vomited1337253_vomited

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.440406115.9
2DLD Change Limit1461622246.50022486.5
3Display Results2242240.0932408.6
 (SQL Overall)1786912247.03325407.5
 
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.