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
performs154748(None) 
perform1439271perform_
preforms1537391preforms
deforms1337802de_forms
paraforms1645562paraforms
perforce1544962perforce
performed17155302performed
performer16145132performer
performers17164102performers
preform1439602preform_
reforms1239812re_forms
aeriform1346083aeriform_
ausforms1343933ausforms
beworms1437923be_worms
conforms1538873conforms
defoams1336193de_foams
deform1259613de_form_
deiform1336683deiform_
deworms1338023de_worms
earworms1346773earworms
eelworms1344553eelworms
efforts1334703_efforts
errors63311313_error_s
fervors1336233fervor_s
forms105327053___forms
informs1248073_informs
isoforms1344343isoforms
leafworms1753613leafworms
misforms1545893misforms
outperforms18121683outperforms
paraform1546923paraform_
parlors9312913parlor_s
peafowls1642893peafowls
pediform1645183pediform_
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
piriform1555743piriform_
pisiforms1643493pisiforms
planforms1643723planforms
platforms1643203platforms
postforms1644603postforms
prearms11369173p_rearms
prefers123713333prefer_s
prefires134313283prefires
prefocus1544743prefocus
preformat1646363preformat
preformats1744413preformats
preformed17176203preformed
preinforms1743233preinforms
prereform1644293prereform_
presorts105311683presorts
preterms1237223preterms
pretors9316803pretor_s
prewarms15406723prewarms
preworks17599003preworks
priors83914483p_rior_s
proems104711163p_r_oems
proforma1545433proforma
proms95426413p_r_o_ms
purports1265783purports
pyriform1844393pyriform_
reform11312703re_form_
reinforms1445083reinforms
serfdoms1443763serfdoms
superfarms1775383superfarms
superfirms1784813superfirms
telfords1244363telfords
teraohms1343703teraohms
termors94712773termor_s
terraforms1552583terraforms
terrors73112213terror_s
uniforms1355043uniforms
webworms1843753webworms

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.1561145455.1
2DLD Change Limit146162987.79618748.3
3Display Results98980.0332969.7
 (SQL Overall)178691987.98522378.3
 
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.