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 “propria” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

98 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
propria114993(None) 
progeria1147942progeria
proprium1447372proprium
propyla14296632propyla
anopia83412393anop_ia
anopsia9258443anopsia
aporia8315863apo_ria
atrophia1348103atrophia
copra98115463_copr_a
coria75828323_co_ria
croppie13278793croppie
emporia1148753emporia
gloria71910543glo_ria
meropia1149613merop_ia
morphia1447483morphia
myopia13318443myop_ia
noria55722183_no_ria
paprica1337003p_aprica
paprika1544003p_aprika
parosmia1245953parosmia
peloria9310953peloria
phobia13278603pho_bia
podia8415283p_o_dia
poori74816233p_oori_
pooris83916843p_ooris
poplin10413483p_oplin
poppa8409893p_op_pa
popsie103013053p_opsie
porphyria19134873porphyria
prairie938333prairie
prepaid12310133prepaid
preppie1058093preppie
prepreg12165963prepreg
preprice1488873preprice
preprint12314183preprint
prepupa1064023prepupa
pretrial10511983pretrial
pretrim11310783pretrim
proa66229963pro___a
probit103218353pro_bit
prodrug1142953prodrug
proemial1249183proemial
profit113016273pro_fit
proforma1545433proforma
progerias1248623progerias
program12311693program
prolix1538683pro_lix
pronota939763pronota
prop85932813prop___
propane112716153propane
propel103714063prop_el
propels113412843propels
propend123311273propend
propene112716043propene
proper104319953prop_er
properdin1446273properdin
properer1259203properer
properly1546463properly
propers113619033propers
property1547073property
prophet14316033prophet
propine113020213propine
propjet1839913propjet
propman1339063propman
propmen1338763propmen
propolis12311403propolis
propone112716303propone
proposal1247743proposal
propose112714843propose
propped113311953propped
propping122811673propping
propriety1645433propriety
props95726883prop__s
propyl13358183prop_yl
propylic1747183propylic
propyls14308193propyls
prosaic11311163prosaic
prosit85124593pro_sit
prosoma11310223prosoma
prossie91812953prossie
prostie91617743prostie
protea82214763pro_tea
protei82615313protei_
proteid103513673proteid
protein92414733protein
proviral1346493proviral
puparia1147353puparia
pyuria1136953p_yuria
raphia113511263_raphia
rosaria749253_rosaria
scoria8513503sco_ria
thoria93012893tho_ria
trophic14311033trophic
tropic103014193trop_ic
tropin83316753trop_in
uropygia1452303uropygia
utopia8107883utop_ia
zoaria1548383_zoaria

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 Filter1786911340270.406440125.6
2DLD Change Limit134027987.37618170.7
3Display Results98980.0462130.4
 (SQL Overall)178691987.82822827.2
 
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.