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

116 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
previous133782(None) 
pervious1337541pervious
precious12310591precious
devious1138522_devious
pluvious1344442pluvious
previews1634512previews
previously1885862previously
previses133814282previses
previsors14126482previsors
provirus1345452provirus
arenous7314183are_nous
arsenious945213arsenious
breviers1335923breviers
cheviots1643783cheviots
cretinous1145893cretinous
crevices1536713crevices
diecious1146873diecious
egregious1143023egregious
envious1037223_envious
fremitus1344023fremitus
gracious1138593gracious
grievous1243583griev_ous
impervious1752963impervious
nervous1037133nerv_ous
obvious1244813_obvious
paviors1237603p_aviors
paviour1244623p_aviour
paviours1343613p_aviours
pereions10310853pereions
perilous10310683perilous
periods10312243p_eriods
peritus9311803p_eritus
petrous92714423p_etrous
pious74621273p___ious
poxvirus2041883poxvirus
prebids12399873prebi_ds
prebills1237293prebills
prebinds13357733prebinds
preboils1267273preboils
prebooks1656293prebooks
precarious1445493precarious
precieuse1344613precieuse
precieux1943033precieux
preciouses1446883preciouses
preciously1746983preciously
precipes143212213precipes
precis103416703preci__s
precises123218333precises
precocious1644743precocious
precooks1656763precooks
precools1237703precools
precoup1336123pre_coup
predacious1544773predacious
predicts1339613predicts
prefiles133113443prefiles
prefires134313283prefires
prefixes20389233prefixes
prefocus1544743prefocus
prelims1139823preli_ms
prelives13310383prelives
premiers122911653premiers
premies113823063premi_es
premises123018273premises
premiss113513813premi_ss
premium13310363premi_um
premiums1437533premiums
premixes193110083premixes
preops104911933pre__ops
preriot9316413prerio_t
preshows16267013preshows
presides11414913presides
presifts1366593presifts
pressors103212673pressors
prestos93716073presto_s
pretors9316803pre_tors
preunions1146483preunions
prevails1337663prevails
prevalue1345073prevalue
prevalues1445323prevalues
prevents133012293prevents
preverbs15295303preverbs
preview1536473previ_ew
previse123713793previ_se
prevised143611073prevised
previsions1547733previsions
previsit13410073previsit
previsits1446793previsits
previsor13116303previsor
prevue1179163prev__ue
prevues1239263prev_ues
prewires133811013prewires
prexies163415003prexi_es
priedieus1242943priedieus
primus103712173pr__imus
prions84317783pr__ions
priors83914483pr__iors
privies122414263privi_es
provides1439883provides
provisoes1446653provisoes
provisos1336913provisos
pruritus1043943pruritus
pulvinus1343263pulvinus
regions83613473_regions
regius7311923_regi_us
reovirus1143423_reovirus
resinous838503_resinous
reviews1335533_reviews
reviles104421353_reviles
revises104220533_revises
revisors11379063_revisors
revives134715543_revives
rubious938273_rubious
serious73616273_serious
specious1247483specious
tedious838443_tedious
unenvious1263243unenvious

Search took 10 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.1561145455.1
2DLD Change Limit1461621168.93616356.5
3Display Results1161160.0462521.7
 (SQL Overall)1786911169.13819554.7
 
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.