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 “yamen” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

117 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
yamen10411518(None) 
amen66733151_amen
ramen75625191ramen
yamens114010821yamens
yamun10419271yamun
admen84516182admen
amend85717752_amend
amens75624842_amens
ament76036542_ament
amin66042252_amin
axmen145112272axmen
badmen114613832badmen
bagmen115412532bagmen
barmen105418532barmen
batmen104414302batmen
baymen134212002baymen
cabmen123610652cabmen
came87648752came_
camel96822802camel
cameo95924992cameo
cames97047312cames
carmen104019342carmen
daimen92210572daimen
daman84821162daman
dame77140312dame_
dames85435852dames
damn75724322dam_n
dampen114310592dampen
daven94916472daven
dawen95413722dawen
eaten55323052eaten
examen1538282examen
fame95639392fame_
famed115928342famed
fames105735922fames
flamen115215992flamen
gaen57329602ga_en
gagmen103910412gagmen
game76644322game_
gamed95126392gamed
gamer84928942gamer
games86238552games
gamey115320552gamey
gamin84423002gamin
gasmen93111562gasmen
haen76229452ha_en
hame97043132hame_
hames106138702hames
haven114718532haven
hymen13311042hymen
kame105728232kame_
kames115024692kames
laden65022192laden
lame66849292lame_
lamed85235292lamed
lament85024942lament
lamer75233702lamer
lames75445542lames
laten54328342laten
lawmen11308592lawmen
laymen113010842laymen
limen75426032limen
lumen75220902lumen
madmen113511742madmen
mamey125418832mamey
maven104816892maven
men59252852__men
name65637412name_
named85223062named
namer75622102namer
names74833362names
nomen75621622nomen
numen74216792numen
oaken95814382oaken
oaten55222402oaten
omen66828182_omen
paten74827342paten
ragmen93712182ragmen
ramee74633852ramee
ramet75743142ramet
raven84723442raven
rumen74419502rumen
same65245642same_
samek114915272samek
seamen84518562seamen
semen75724102semen
stamen84115942stamen
taken94819142taken
tame66343662tame_
tamed85528512tamed
tamein8313092tamein
tamer75230102tamer
tames75242012tames
taxmen15367442taxmen
vanmen1138402vanmen
vimen104114752vimen
waken124818472waken
wame95035482wame_
wames106432802wames
waxen154911812waxen
women104619252women
yager95616752yager
yam87448992yam__
yammer133713182yammer
yams95330732yam_s
yamuns11336512yamuns
yapon104613582yapon
yardmen1335422yardmen
yare75636942yare_
yarer84321572yarer
yarn75230042ya_rn
yawed126022452yawed
yawey14458272yawey
yawn106219092ya_wn
yen66847382y__en
yeomen1138182yeomen
zazen1337282zazen

Search took 2 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 Filter178691538000.296603685.8
2DLD Change Limit538001171.53035163.4
3Display Results1171170.0333545.5
 (SQL Overall)1786911171.85996122.1
 
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.