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

91 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
adwomen134568(None) 
adwoman1345431adwoman
madwomen1644791madwomen
abdomen1237022abdomen
admen84516182ad__men
agnomen1036762agnomen
airwomen1344822airwomen
automen939652automen
awoken13457162a_woken
laywomen1643702laywomen
madwoman1643692madwoman
radiomen1146632radiomen
women104619252__women
abdomens1345243abdomens
acrogen1038193acrogen
acumen1049013a_cumen
adeemed1145393adeemed
adjoin14107293adjo_in
adjourn1563433adjourn
adman84517903ad__man
adnoun757033adno_un
adobe84814713ad_obe_
adobes94411533ad_obes
adore65723673ad_ore_
adored84714243ad_ored
adorer74713453ad_orer
adores74420723ad_ores
adorn64917093ad_o_rn
adown95611663ad_o_wn
adoze155713833ad_oze_
agnomens1144893agnomens
aidmen92610373a_idmen
airmen82612353a_irmen
airwoman1344673airwoman
albumen1135243albumen
aldermen1145043aldermen
alderwomen1652383alderwomen
almsmen1144583almsmen
amen66733153a___men
androgen1046313androgen
ashmen1168173a_shmen
aswoon947013aswo_on
atween9166613atw_een
automan9310883automan
autopen947123autopen
awaken13468863a_waken
awoke124912003a_woke_
axemen1547493a_xemen
axmen145112273a__xmen
badmen114613833bad__men
bondwomen1744203bondwomen
bowmen1399853bow_men
charwomen1944593charwomen
cowmen13810923cow_men
daimen92210573_daimen
dawen95413723daw__en
daysmen1335083daysmen
dolmen93911373_dolmen
dome77240733_d_ome_
domed95423263_d_omed
domes85735563_d_omes
doomed104113293_doomed
doormen1036753_doormen
doven94718553_d_oven
doyen95014413_d_oyen
dozen155017473_d_ozen
dromon939363_dromon
handwoven1943213handwoven
inwoven13175523inwoven
lawmen11308593law_men
laywoman1643363laywoman
madmen113511743mad__men
newsmen1235893newsmen
nomen75621623__nomen
oarswomen1443373oarswomen
omen66828183___omen
plowmen1434883plowmen
radioman1145773radioman
radome9511873rad_ome_
radomes10311053rad_omes
rewoken145112293rewoken
rewoven13557933rewoven
showmen15227173showmen
snowmen12246153snowmen
unwoven13176673unwoven
washwomen2082963washwomen
woken124614973__woken
woman105818003__woman
womyn13426363__womyn
woven115215173__woven
yeomen1138183_yeomen

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.1561145455.1
2DLD Change Limit134027916.93619323.4
3Display Results91910.0332757.6
 (SQL Overall)178691917.12525079.4
 
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.