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 “performs” 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
performs154749(None) 
perform1439291perform_
preforms1537411preforms
deforms1337802de_forms
paraforms1645582paraforms
perforce1544962perforce
performed17155302performed
performer16145132performer
performers17164102performers
preform1439622preform_
reforms1239822re_forms
aeriform1346103aeriform_
ausforms1343933ausforms
beworms1437933be_worms
conforms1538873conforms
defoams1336193de_foams
deform1259633de_form_
deiform1336703deiform_
deworms1338033de_worms
earworms1346783earworms
eelworms1344563eelworms
efforts1334703_efforts
errors63311313_error_s
fervors1336233fervor_s
forms105327053___forms
informs1248073_informs
isoforms1344343isoforms
leafworms1753613leafworms
misforms1545893misforms
outperforms18121683outperforms
paraform1546943paraform_
parlors9312923parlor_s
peafowls1642893peafowls
pediform1645193pediform_
pelorus939273pe_lorus
percoids1339663percoids
perdures11289683perdures
pereons92815003pereo_ns
perfects15107353perfects
perforate1459463perforate
perforates1558863perforates
performing1844943performing
perfume1446503perf_ume
perfumes1555893perfumes
perfumy1763933perf_umy
perfuses1358663perfuses
pergolas1158233pergolas
periderms1444993periderms
periods10312243perio_ds
perjures17268083perjures
perms95524513pe___rms
pernods1038483perno_ds
peroral9314793per_oral
perrons93115483perro_ns
personas102511883personas
persons93717013perso_ns
perturbs1244363perturbs
perverts1337533perverts
piedforts1542483piedforts
pieforts1344863pieforts
pinworms15115783pinworms
piriform1555763piriform_
pisiforms1643503pisiforms
planforms1643733planforms
platforms1643213platforms
postforms1644603postforms
prearms11369173p_rearms
prefers123713333prefer_s
prefires134313283prefires
prefocus1544743prefocus
preformat1646363preformat
preformats1744413preformats
preformed17176203preformed
preinforms1743253preinforms
prereform1644313prereform_
presorts105311683presorts
preterms1237223preterms
pretors9316813pretor_s
prewarms15406733prewarms
preworks17599013preworks
priors83914483p_rior_s
proems104711163p_r_oems
proforma1545433proforma
proms95426413p_r_o_ms
purports1265783purports
pyriform1844413pyriform_
reform11312723re_form_
reinforms1445083reinforms
serfdoms1443763serfdoms
superfarms1775383superfarms
superfirms1784813superfirms
telfords1244373telfords
teraohms1343703teraohms
termors94712773termor_s
terraforms1552593terraforms
terrors73112213terror_s
uniforms1355043uniforms
webworms1843763webworms

Search took 9 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 Limit146162987.81318707.5
3Display Results98980.0462130.4
 (SQL Overall)178691988.29521542.0
 
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.