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

99 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
procarp134682(None) 
procarps1445971procarps
apocarp1355132apocarp
exocarp1843852exocarp
pericarp1446122pericarp
podocarp1543462podocarp
procure1138572procure
prowar114110942prowar_
sporocarp1552822sporocarp
trocar848772trocar_
trocars959042trocars
apocarps1474423apocarps
apocarpy1743013apocarpy
ascocarp1442693ascocarp
brocade1238533brocade
carp85139813___carp
endocarp1343733endocarp
epicarp1376073epicarp
escarp10449003_escarp
exocarps1953473exocarps
froward1436673froward
grocer94212143grocer_
grocers103511253grocers
grocery13336763grocery
mesocarp1443983mesocarp
monocarp14136113monocarp
peccary1636283peccary
pericarps1544473pericarps
picara10311903p_icara
picaro10311323p_icaro
piscary1437423piscary
placard1236783placard
pochard1537363p_ochard
polar75623453p_olar_
polars84419353p_olars
preamp1238993pr_eamp
prearm104512353pr_earm
precast11314853precast
precava1445093precava
precoup1336123precoup
precure11312553precure
prepare111913623prepare
prewar114712583prewar_
prewarm14479613prewarm
prewarn124410153prewarn
prewrap14104973prewrap
pricer103918293pricer_
pricers113915063pricers
primary1437703primary
proa66229963pro_a__
proas75028803pro_a_s
proband122710243proband
probang12278383probang
probate11414483probate
prober104516073prober_
probers113514583probers
procaine12312273procaine
proceed12310553proceed
process11310403process
prochain1548483prochain
proclaim1446073proclaim
proctor11310433proctor
proctors12311513proctors
procural1246923procural
procured1336603procured
procurer1235833procurer
procures1239213procures
profane122111863profane
program12311693program
prolan8414693prola_n
prolans9314273prolans
prolate9419793prolate
pronate9418873pronate
prop85932813pro___p
propane112716153propane
proper104319953proper_
propers113619033propers
prorate9418733prorate
prosaic11311163prosaic
proser84223463proser_
prosers94219643prosers
prover113819723prover_
proverb14378213proverb
provers123817793provers
prower114218123prower_
recap95718023_reca_p
roar46328573_ro_ar_
roars55622243_ro_ars
rosary92810353_rosary
rotary92411303_rotary
sarcocarp1552373sarcocarp
scarp95724103__scarp
sporocarps1652493sporocarps
syncarp1444533syncarp
trochar1257073trochar_
trochars1377853trochars
uproar8106933upro_ar_
uproars986453upro_ars
xylocarp2262413xylocarp

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.423422437.4
2DLD Change Limit134027996.86019537.5
3Display Results99990.0462152.2
 (SQL Overall)178691997.32924381.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.