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

89 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
almsmen114458(None) 
almsman1145091almsman
albumen1135242albumen
dalesmen1146202dalesmen
helmsmen1552842helmsmen
salesmen1047252salesmen
talesmen1047012talesmen
abdomen1237023abdomen
acumen1049013a_cumen
admen84516183a__dmen
adwomen1345683adwomen
agnomen1036763agnomen
aidmen92610373a_idmen
airmen82612353a_irmen
alarmed1037733alarmed
albumens1244143albumens
albumin1145563albumin
aldermen1145043aldermen
alien56425583al__ien
aliment9316703al_iment
allseed835953allseed
alme65832163al__me_
almeh106214553al__meh
almemar1144303almemar
almes75126543al__mes
almner85710723alm_ner
almoner949383almoner
alms65834923alms___
almuce10348213almuce_
almuces11316823almuces
almude9399933almude_
almudes10418263almudes
alumin8513543al_umin
amen66733153a___men
arisen65316793aris_en
armament1249633armament
ashen87818673a__shen
ashmen1168173a_shmen
aspen75216093a__spen
automen939653automen
axemen1547493a_xemen
axmen145112273a__xmen
bailsmen1244623bailsmen
bandsmen1356453bandsmen
batsmen1146883batsmen
bluesmen1244153bluesmen
busmen1039893_busmen
clansmen1245723clansmen
clubmen1334253clubmen
dalesman1145803dalesman
daysmen1335083daysmen
flagmen13226913flagmen
flamen115215993fl_amen
flehmen1534913flehmen
flymen14387773fl_ymen
gamesmen1345113gamesmen
gasmen93111563_gasmen
glassmen1145393glassmen
gleemen1035723gleemen
glisten8418083glisten
helmsman1553503helmsman
kamseen1344013kamseen
kinsmen1335653kinsmen
lammed113915623lam_med
lamster9109913lamster
landmen1038553landmen
landsmen1156603landsmen
lawmen11308593_lawmen
laymen113010843_laymen
legmen939343_legmen
lensmen937883lensmen
lessen64212433_lessen
limen75426033_l_imen
listen64816813_listen
lumen75220903_l_umen
malmsey1433623malms_ey
marksmen1644533marksmen
messmen1137393messmen
newsmen1235893newsmen
oarsmen938093oarsmen
plasmin112410033plasmin
plasmon11257983plasmon
plowmen1434883plowmen
raftsmen1343953raftsmen
rodsmen1035833rodsmen
salesman1047353salesman
talesman1046693talesman
talisman1045553talisman
tallymen1343523tallymen

Search took 10 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.1401276364.3
2DLD Change Limit134027899.26614464.4
3Display Results89890.390228.2
 (SQL Overall)178691899.79618241.2
 
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.