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

299 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
prevised14361107(None) 
precised133213411precised
premised133013191premised
previse123713791previse_
previses133814281previses
revised113815481_revised
creviced1634452creviced
devised123712562_devised
peised94817682p_e_ised
poetised1138522poetised
praised104214812pr_aised
precise113518172precise_
preciser123411662preciser
precises123218332precises
precited133013812precited
prefiled143310572prefiled
prefired144310752prefired
prefixed21357702prefixed
premise113818552premise_
premises123018272premises
premixed20338012premixed
prerinsed1246322prerinsed
presided12410552presided
pressed103317312pre_ssed
prevailed1536042prevailed
preview1536472previ_ew
previewed1843422previewed
previsit13410072previsit
previsited1645182previsited
previsor13116302previsor
prevued1337142prev_ued
prewired14358472prewired
prised94322202pr__ised
promised133010882promised
provided1536842provided
remised103516842_remised
reviled114417922_reviled
revise94019742_revise_
reviser104114662_reviser
revises104220532_revises
revived144211652_revived
unrevised1345162unrevised
advised12136043_advised
braised104014803br_aised
breveted1435623breveted
brevier1237763brevi_er
brewises1337213brewises
bruised10389503br_uised
chevied16357483chevi_ed
clevises1336903clevises
creased104315593cre_ased
credited1238253credited
creolised1255213creolised
crevassed1543203crevassed
crevice1436153crevice_
crevices1536713crevices
cruised103710223cr_uised
demised113613683_demised
deviled124112183_deviled
devise104215753_devise_
devisee113812713_devisee
deviser114212393_deviser
devises114116763_devises
dressed93511873dre_ssed
elegised10145923elegised
evited104013143__evited
greased93812393gre_ased
grecized2134433grecized
greisen856503gre_isen
improvised1873573improvised
irised73913153ir__ised
itemised11105163itemised
levied104111433_levi_ed
obelised1136173obelised
parvise124211693parvise_
parvises133911923parvises
pavise114714803p_avise_
paviser12489093p_aviser
pavises125315493p_avises
peeved124112893peev__ed
peevish1535783peevis_h
peined94918843p_e_ined
peise75825773p_e_ise_
peises84125043p_e_ises
pelvises1337273pelvises
penises9318193p_enises
perfused1445843perfused
periled10316323p_eriled
perished14310093p_erished
persisted1247153persisted
perused103112203p_erused
pervaded1535373pervaded
phrensied1543383phrensied
pleased103712073ple_ased
plenished1584953plenished
poetise9314043poetise_
poetiser1037313poetiser
poetises10313953poetises
poetized2037983poetized
poised94918473p__oised
porpoised1445463porpoised
practised1446103practised
praise84419413pr_aise_
praiser93413943pr_aiser
praises94121113pr_aises
praxises1739063praxises
preached163412063preached
preacted132710943preacted
preaged11612333pre_aged
prearmed1397993prearmed
prebaked1737173prebaked
prebid113512843prebi__d
prebilled1445063prebilled
prebind123810643prebi_nd
preboiled1455783preboiled
preceded1438293preceded
precessed1437523precessed
precipe133012123precipe_
precipes143212213precipes
precis103416703precis__
precisely1645353precisely
precisest13259003precisest
precoded1438863precoded
precured1339993precured
predated12513273predated
predicted1538913predicted
predive13511083predive_
predried12309573predried
preed85128123pre___ed
preedited1337633preedited
preened103214993pre_ened
preexisted2043783preexisted
prefaced1638423prefaced
prefaded1537823prefaded
prefile123413183prefile_
prefiles133113443prefiles
prefilled1535513prefilled
prefire124012813prefire_
prefires134313283prefires
prefixes20389233prefixes
preguided1443923preguided
preinvited1663923preinvited
prelife1279943prelife_
prelives13310383prelives
preluded1236473preluded
premed114617763pre__med
premie103617993premi_e_
premier113515633premi_er
premiered14237093premiered
premies113823063premi_es
premiss113513813premis_s
premisses13288763premisses
premixes193110083premixes
prenticed14118063prenticed
preowned1435213preowned
prepared132210873prepared
prepasted14137673prepasted
prepaved16177233prepaved
prepped11329903pre_pped
prepriced1676643prepriced
prerinse1038633prerinse_
prerinses1138813prerinses
presaged1238813presaged
prese75228383pre__se_
preset84430983pre__set
preside10715613preside_
presider11410423presider
presides11414913presides
presifted1536873presifted
presliced1435983presliced
presser93717623pre_sser
presses93523153pre_sses
presumed1337973presumed
pretaped13339133pretaped
pretasted12147963pretasted
pretested12149113pretested
prettied1159253prettied
pretyped16306123pretyped
preunited1246803preunited
prevailer1445153prevailer
prevalued1544553prevalued
prevented1539003prevented
previewer1743023previewer
previews1634513previews
previous1337823previous
prevising15510873prevising
prevision1448003prevision
previsioned1744263previsioned
previsits1446793previsits
previsors14126483previsors
prevue1179163prev_ue_
prevues1239263prev_ues
prewashed1843923prewashed
prewire124311143prewire_
prewires133811013prewires
prexies163415003prexi_es
preyed125313203pre__yed
priced115018883pr__iced
prided103618033pr__ided
pried84426863pr__i_ed
primed115118913pr__imed
prise74632613pr__ise_
prises84133173pr__ises
prissed103311263pr_issed
privatised16134993privatised
privier122910453privi_er
privies122414263privi_es
priviest132310313priviest
prized184415393pr__ized
profiled14338523profiled
profited14279973profited
promise113415843promise_
promisee122711333promisee
promiser122510673promiser
promises122916763promises
propined133111513propined
proposed132011083proposed
prosed94921103pr__osed
proved125016033prov__ed
provide1339853provide_
provider1436703provider
provides1439883provides
proviso1237313provis_o
provisoes1446653provisoes
provisos1336913provisos
provoked1875053provoked
raised76120333_r_aised
ravined115411823_ravined
ravished1555713_ravished
realised92214533_realised
recited104319103_recited
recused104714433_recused
refiled114318653_refiled
refined114720003_refined
refired115116993_refired
refixed183611153_refixed
refused115114443_refused
rehired115013153_rehired
reined74425523_re_ined
reived104518133_re_ived
relied74926233_reli_ed
relined85321933_relined
relished1239433_relished
relisted9312623_relisted
relived115114683_relived
remise84221953_remise_
remises93423483_remises
remixed173510743_remixed
reoiled84316853_reoiled
repined104918773_repined
reposed103616283_reposed
reprised112012213_reprised
reraised9312363_reraised
rerise64325633_rerise_
rerisen73613643_rerisen
rerises73525883_rerises
resided95217703_resided
resiled84621983_resiled
resined84522653_resined
resisted9312693_resisted
resited85122423_resited
resized174614903_resized
retied75924983_reti_ed
retiled84420513_retiled
retimed104714653_retimed
retired84620143_retired
reused75419563_re_used
reveled113917753_reveled
revered112819333_revered
reversed122711613_reversed
revested122612243_revested
review1238693_revi_ew
reviewed1534823_reviewed
revile94921613_revile_
reviler104314973_reviler
reviles104421353_reviles
revisal1038263_revisal
revisers113511933_revisers
revisit10311373_revisit
revisited1346573_revisited
revisor10388733_revisor
revive124914823_revive_
reviver134411373_reviver
revives134715543_revives
revoiced14317873_revoiced
revoked154410523_revoked
revoted114314153_revoted
revulsed1235443_revulsed
revved13469723_rev_ved
rewired115413283_rewired
seised74218123_se_ised
serviced1435613serviced
supervised1646663supervised
televised1344243televised
trellised1044653trellised
tressed83714263tre_ssed
upraised11167413upr_aised
vised95518763___vised
weeviled1533143weeviled

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.436409841.7
2DLD Change Limit1461622996.47022590.7
3Display Results2992990.1262373.0
 (SQL Overall)1786912997.03225411.1
 
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.