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

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

82 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
clergymen175202(None) 
clergyman1751911clergyman
clergywomen2261222clergywomen
cerumen1147763c_er_umen
clergies1137903clerg_ies
clergy1234993clergy___
clergywoman2261203clergywoman
energumen1253073energumen
everymen1644423ever_ymen
ferrymen1643943_ferrymen
legmen939343_le_g_men
aldermen1145044alder__men
alderwomen1652384alderwomen
allergen9135894allerg__en
bargemen1346404_bargemen
berhyme1743814_berhyme_
berhymed1943314_berhymed
berhymes1843804_berhymes
bogymen1534764__bogymen
boogymen1643104_boogymen
cameramen1544134camer_amen
carmen104019344c_ar__men
cerement12315134c_er_ement
cermet10321154c_er__met
cerumens1235764c_er_umens
charwomen1944594charwomen
chessmen1544464che_ssmen
choremen1597604chor_emen
churchmen2142924churchmen
clansmen1245724cl_ansmen
cleareyed1572114clearey_ed
clement11313774cle___ment
cleome1039084cle__ome_
cleomes1138814cle__omes
clerihew1642684cler_ihew
clerisies1147254clerisies
clerked14326654cler__ked
clerklier1542184clerklier
clubmen1334254cl__ubmen
clubwomen1852124clubwomen
coenzyme2442994coenzyme_
coenzymes2542574coenzymes
colormen1247244color__men
corpsmen1445624c_orpsmen
cragsmen1344764c_ragsmen
crewmen1436374c__rewmen
dairymen1443314dair_ymen
draymen1335234__draymen
energumens1352794energumens
evergreen1342254evergreen
everyman1643514ever_yman
ferryman1643814_ferryman
flagmen13226914fl_ag_men
flehmen1534914fle__hmen
flymen14387774fl___ymen
germen9612314_ger__men
gleemen1035724gle__emen
hegumen1355464_he_gumen
herdmen13238454_her_dmen
herdsmen1464834_herdsmen
jurymen1943134_jur_ymen
laymen113010844_l__aymen
leadmen10277904_le_admen
leadsmen1154794_leadsmen
legman949654_le_g_man
legume936914_le_gume_
legumes1036634_le_gumes
legumin1045074_le_gumin
lengthen1243534_lengthen
lensmen937884_le_nsmen
liegemen1144134_liegemen
liverymen1742814liver_ymen
mermen10813814_mer__men
overmen12311804over__men
quarrymen2352334quarrymen
regimen104411574_re_gimen
salarymen1472684salar_ymen
tegmen988404_te_g_men
tegumen10105424_te_gumen
versemen1346854_versemen
weighmen1743464_weighmen
yeggmen1442674_ye_ggmen

Search took 12 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 Filter1786911653290.436409841.7
2DLD Change Limit1653298211.44014451.8
3Display Results82820.0302733.3
 (SQL Overall)1786918211.90615008.5
 
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.