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

78 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
prenomen124963(None) 
praenomen1345011praenomen
prenomens1347071prenomens
penmen10311492p_en_men
phenomena1645212phenomena
praenomens1453662praenomens
premen105017802pre__men
prename11412642prename_
prenames12311632prenames
prenomina1347882prenomina
prenoon9310042preno_on
pressmen1238832pressmen
agnomen1036763_agnomen
arenose7311373arenose_
cognomen1346083cognomen
crewmen1436373cre_wmen
dragomen1245013dragomen
forewomen1746463forewomen
freedmen1444553freedmen
freemen1238463fre_emen
freshmen1656023freshmen
frontmen1344423frontmen
genome94312193_genome_
genomes103611703_genomes
ironmen936453iron_men
ironwomen1443983ironwomen
lensmen937883_lensmen
nomen75621623___nomen
oenomel946563_oenomel
penman10312323p_en_man
phenom1339473phenom__
phenomenal1754263phenomenal
phenomenas1754623phenomenas
phenomenon1753293phenomenon
phenoms1437813phenom_s
pointmen1245423pointmen
praenomina1453233praenomina
prearmed1397993prearmed
prechosen16116243prechosen
precode12311853precode_
precoded1438863precoded
precodes13711573precodes
preen75925053pre___en
preformed17176203preformed
prefrozen2352843prefrozen
pregame1239553pregame_
pregames1339003pregames
prehuman1545033prehuman
preman104117453pre__man
premed114617753pre__med
premodern1444423premodern
prenotion1149173prenotion
prenumber1543163prenumber
prepotent1349573prepotent
pressman1247153pressman
presume11310303presume_
presumed1337973presumed
presumer1247583presumer
presumes1239843presumes
preteen939873pre_teen
preworn124711213prewo_rn
pronoun939033prono_un
propmen1338763pr_opmen
proven114314773pr__oven
reedmen1038333_reedmen
regimen104411573_regimen
reinsmen1047073_reinsmen
rename82718813_rename_
renamed103114523_renamed
renames92418053_renames
renown9369983_reno_wn
reopen8311573_re_open
rewoken145112293_rewoken
rewoven13557933_rewoven
tirewomen14104283tirewomen
venomed1336653_venomed
venomer1237583_venomer
yeomen1138183_ye_omen

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 Filter1786911461620.1561145455.1
2DLD Change Limit146162787.68619016.7
3Display Results78780.0332363.6
 (SQL Overall)178691787.87522690.9
 
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.