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

159 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
provost123857(None) 
provosts1336081provosts
promos105116422promos_
propose112714842propose
prosos85718552prosos_
prost75434102pr__ost
protest9317532protest
protist9320222protist
proves114322252proves_
proviso1237312proviso
provoke1676122provoke
prowest12311532prowest
roost55730932_ro_ost
apropos1138843apropos_
arvos86015663ar_vos_
boost75132473_bo_ost
bravest124211753bravest
bravos114711393bravos_
bromos104213313bromos_
broos75126413bro_os_
cohost115217213_cohost
dropout10410003dropout
droves105116673droves_
frost84727833fr__ost
frowst125512073fro_wst
gravest114011633gravest
groves104318103groves_
irokos1037233irokos_
ironist7314843ironist
parodist11412763parodist
parodos103011753parodos_
parvos116614753parvos_
phonos114114793phonos_
photos113316643photos_
photoset13414283photoset
pivot106523873p_ivo_t
pivots115111903p_ivots
poloist91016323p_oloist
polos76129913p_olos_
pomos95321583p_omos_
poorest9312773poorest
poos65949113p_o_os_
pooves113914713pooves_
pornos85015253pornos_
porose84818743p_orose
post67953363p___ost
praos74923563pr_aos_
precast11314853precast
premolt11312073premolt
presort95219543presort
prest75736353pr__est
pretest9517633pretest
prevent124016553prevent
previse123713793previse
previsit13410073previsit
priest84125423pr_iest
primos104514423primos_
privet113821343priv_et
privets122910053privets
priviest132310313priviest
proas75028803pro_as_
probes104119453probes_
probit103218353pro_bit
probits112712573probits
process11310403process
prods85523553pro_ds_
product1279233product
proems104711163proems_
profess1237713profess
profit113016273pro_fit
profits122911243profits
profs105120893pro_fs_
profuse1237153profuse
prognose1146463prognose
progs86624153pro_gs_
project1838453project
projet15315183pro_jet
projets1639163projets
proles84627203proles_
prolog94212973prolo_g
prologist12315083prologist
prologs103512133prologs
prolong10319633prolong
promise113415843promise
promo95620003promo__
promoed12310083promoed
promote11313143promote
prompt12313013pro_mpt
prompts1337473prompts
proms95426413pro_ms_
prongs94314483prongs_
pronota939763pronota
pronoun939033pronoun
proof105221533pro_o_f
proofs114511683pro_ofs
prophet14316033prophet
propjet1839913propjet
propone112716303propone
proposal1247743proposal
proposed132011073proposed
proposer121810633proposer
proposes122515973proposes
propositi1368473propositi
props95726883pro_ps_
pros65742783pr__os_
prosaist10611583prosaist
prose75835123pr__ose
prosect11313393prosect
proses84733473proses_
prosiest10416523prosiest
prosit85124593pro_sit
proso77222413pr__oso
prosodist1248913prosodist
prosody1336433prosody
prosoma11310223prosoma
pross76529403pr__oss
prosy106319253pr__osy
protect11313633protect
proteose10229413proteose
protests10310493protests
protists10313363protists
proton84318893proto_n
protons93118003protons
protostar1146693protostar
proudest1138943proudest
prove104823193prov__e
proved125016033prov_ed
proven114314773prov_en
prover113819723prov_er
proverb14378213proverb
provers123817793provers
provide1339853provide
proving134214073proving
provisos1336913provisos
provoked1875053provoked
provoker1784913provoker
provokes1776603provokes
prowess1237903prowess
prowls115511083prowls_
prows106327013pro_ws_
prutot8311823pruto_t
revest94623603_revest
revolt9316223_revolt
ripost83615003_ripost
roast56230143_ro_ast
robot7325973_robo_t
robots8313153_robots
robust8310433_robust
roose56127093_ro_ose
roosts64916323_ro_osts
root45655923_ro_o_t
roots55933673_ro_ots
rotos56027883_rotos_
roust55532063_ro_ust
roves84834483_roves_
troves94719113troves_
uproot8314123upro_o_t
uproots937143upro_ots
volost9412643_volost

Search took 7 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.390458182.1
2DLD Change Limit1340271596.45320769.7
3Display Results1591590.0632523.8
 (SQL Overall)1786911596.90625874.7
 
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.