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

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

184 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
sagamen1012750(None) 
sagaman10117561sagaman
bagmen115412532bag_men
gagmen103910412gag_men
ragmen93712182rag_men
sandmen1039412sandmen
seamen84518562s_eamen
stamen84115942s_tamen
swagmen1334972swag_men
acumen1049013_acumen
admen84516183_a_dmen
again65218123_aga_in
agama85815583_agam_a
agamas97413453_agamas
agamete1037393_agamete
agamic113110563_agamic
agamid103710693_agamid
agape85614843_agape_
agapes95212413_agapes
agate66525143_agate_
agates76121343_agates
agave95314033_agave_
agaves104611513_agaves
agaze156113663_agaze_
agnomen1036763_agnomen
aidmen92610373_aidmen
airmen82612353_airmen
amen66733153___amen
arame75026623_arame_
arames84622573_arames
ashamed1336243ashamed
ashmen1168173_ashmen
ataman81013063_ataman
awaken13468863_awaken
axemen1547493_axemen
axmen145112273_a_xmen
badmen114613833ba_dmen
bagman114613813bag_man
bargemen1346403bargemen
barmen105418533ba_rmen
basemen1139083basemen
batmen104414303ba_tmen
batsmen1146883batsmen
baymen134212003ba_ymen
bogymen1534763bogymen
cabmen123610653ca_bmen
caramel11310253caramel
carmen104019343ca_rmen
cavemen1437143cavemen
cragsmen1344763cragsmen
daimen92210573da_imen
daysmen1335083daysmen
degame102713183degame_
degames113312623degames
dragomen1245013dragomen
duramen1096903duramen
examen1538283_examen
flagmen13226913flag_men
flamen115215993_flamen
foramen12310533foramen
gaen57329603__ga_en
gagman103811243gag_man
game76644323__game_
gamed95126393__gamed
gamer84928943__gamer
games86238553__games
gamey115320553__gamey
gamin84423003__gamin
gasmen93111563ga_smen
gatemen1047603gatemen
gravamen1443933gravamen
hackmen1836713hackmen
hangmen1337383hangmen
hegumen1355463hegumen
jazzmen2442503jazzmen
lagan66520343laga__n
landmen1038553landmen
lawmen11308593la_wmen
laymen113010843la_ymen
legmen939343leg_men
ligament1149313ligament
madame1139853madame_
madames12310063madames
madmen113511743ma_dmen
magdalen1243533magdalen
mailmen1137273mailmen
oarsmen938093oarsmen
packmen1746313packmen
pagan86121163paga__n
parament12415393parament
putamen1135923putamen
ragman94013713rag_man
ramen75625193__ramen
regimen104411573regimen
sabaton937713sabaton
sabayon1244233sabayon
sacaton938993sacaton
sacrament1347943sacrament
sadden83212403sa_dden
saga55331173saga___
sagamore1144343sagamore
sagamores1244183sagamores
sagas66025883saga__s
sage55044593sag__e_
sager65432053sag__er
sages65339063sag__es
saggared11326063saggared
sagged94120003sag_ged
sagger84321073sag_ger
saggier92912063saggier
sagier73717163sag_ier
sagum8512873sagum__
saimin8313663sa_imin
salaamed1134623salaamed
salami8313103salam_i
salamis9313513salamis
salarymen1472683salarymen
salesmen1047253salesmen
salmon84614183sa_lmon
same65245643s__ame_
samek114915273s__amek
samisen937673samisen
sandman10310173sandman
sangaree949333sangaree
saran53730303sara__n
sarape84817573sarape_
sarapes94617743sarapes
sarment9318763sa_rment
sarsen6314233sa_rsen
sateen63815013sa_teen
savage10410173savage_
savaged1236993savaged
savager1137133savager
savages1139973savages
savarin10310003savarin
savate9313783savate_
savates10312953savates
seaman84015903s_eaman
seamed94823883s_eamed
seamer84223613s_eamer
seedmen1037683seedmen
segment10312563seg_ment
semen75724103s__emen
sesame8311013sesame_
sesames9310743sesames
shagreen1243443shagreen
shaken134113613s_haken
shaman113314283s_haman
shame105726703s_hame_
shamed125120213s_hamed
shames114726223s_hames
shapen114414653s_hapen
shaven124213303s_haven
shipmen14317283shipmen
shopmen14277193shopmen
showmen15227163showmen
sidemen1037943sidemen
signalmen1252443signalmen
skymen1535313s_kymen
snowmen12246153snowmen
sockmen1535453sockmen
socmen1039193s_ocmen
sokemen1337053sokemen
sonarmen1045253sonarmen
spacemen1445413spacemen
spearmen1234853spearmen
stamens93411483s_tamens
steamed103712143steamed
steamer93313093steamer
sugared938583sugared
sugarer837323sugarer
surfmen1235993surfmen
swagman1334913swag_man
taximen1644923taximen
taxmen15367443ta_xmen
tegmen988403teg_men
tegumen10105423tegumen
vanmen1138403va_nmen
velamen1237123velamen
wakame1535433wakame_
wakames1635283wakames
yamen104115183__yamen
yardmen1335423yardmen
yeggmen1442673yeggmen

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.1401276364.3
2DLD Change Limit1340271846.87319500.5
3Display Results1841840.0632920.6
 (SQL Overall)1786911847.07625253.1
 
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.