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

152 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
sagaman1011756(None) 
sagamen10127501sagamen
agama85815582_agama_
agamas97413452_agamas
ataman81013062_ataman
bagman114613812bag_man
gagman103811242gag_man
ragman94013712rag_man
sandman10310172sandman
seaman84015902s_eaman
shaman113314282s_haman
swagman1334912swag_man
adamant101110443_adamant
adman84517903_a_dman
again65218123_aga_in
agamic113110563_agamic
agamid103710693_agamid
agapae9388043_agapae
agapai9456863_agapai
agma77623263_ag_ma_
agmas85919873_ag_mas
aidman92410623_aidman
airman82414223_airman
ashman1148383_ashman
asrama839193asrama_
asramas938303asramas
atamans9710433_atamans
atman75520143_a_tman
axeman1538103_axeman
axman144813183_a_xman
badman113813843ba_dman
bagmen115412533bag_men
bargeman1345143bargeman
barman103519703ba_rman
baseman1138553baseman
batman105214063ba_tman
batsman1157993batsman
bayman133712703ba_yman
bogyman1544933bogyman
cabman123812503ca_bman
caiman103615663ca_iman
calamar1149293calamar
caravan1239233caravan
carman103920743ca_rman
caveman1437073caveman
cayman133613213ca_yman
cragsman1345213cragsman
daman84821163__daman
daysman1335053daysman
dragoman1244653dragoman
flagman13186173flag_man
gagmen103910413gag_men
gama77035523__gama_
gamas85431363__gamas
gamay116419113__gamay
gamin84423003__gamin
gasman92911743ga_sman
gateman1057473gateman
hackman1836433hackman
hangman1337813hangman
hanuman1237133hanuman
jacamar1844323jacamar
jazzman2442553jazzman
lagan66520343lag__an
landman1038923landman
lawman11289053la_wman
layman113511303la_yman
legman949653leg_man
madman113712383ma_dman
magian9312833mag_ian
magma104513573mag_ma_
magmas115512503mag_mas
mailman1137733mailman
nagana748943nagana_
naganas847983naganas
oarsman937733oarsman
packman1736693packman
pagan86121163pag__an
pajama17317653pajama_
pajamas18278153pajamas
panama104213353panama_
panamas113112763panamas
papayan1445303papayan
patamar1147093patamar
raglan73711503rag_lan
ragmen93712183rag_men
sabaton937713sabaton
sabayon1244233sabayon
sacaton938993sacaton
saga55331173sag__a_
sagamore1144343sagamore
saganash1243073saganash
sagas66025883sag__as
saggar84010853sag_gar
sagum8512873sagum__
saimin8313663sa_imin
salaam8711013sala_am
salaams997703salaams
saladang1043843saladang
salami8313103salam_i
salamis9313513salamis
salaryman1462653salaryman
salesman1047353salesman
salmon84614183sa_lmon
salpian938493salpian
saltpan935303saltpan
samara8313853samara_
samaras9312913samaras
sampan102511893sa_mpan
sandmen1039413sandmen
saraband1146193saraband
saran53730303s__aran
satara6315533satara_
sataras7315063sataras
saurian739913saurian
savanna1043713savanna
savarin10310003savarin
seamen84518563s_eamen
seawan94111223s_eawan
seedman1037373seedman
shamans123610903s_hamans
shamas113717943s_hamas
shipman14247133shipman
shopman14247263shopman
showman15257293showman
siamang1045333s_iamang
sideman1037973sideman
sigma84513833sig_ma_
sigmas94111363sig_mas
signalman1272093signalman
skyman1535313s_kyman
snowman12226623snowman
sockman1535663sockman
socman1039813s_ocman
sokeman1337263sokeman
soman75024903s__oman
sonarman1045563sonarman
spaceman1445323spaceman
spearman1244943spearman
squama1736533squama_
squamae1845723squamae
stamen84115943s_tamen
surfman1236203surfman
swagmen1334973swag_men
tarama8412733tarama_
taramas9612703taramas
taximan1635783taximan
taxman15328613ta_xman
vanman1139793va_nman
yardman1335913yardman
yatagan1144133yatagan
yeggman1442923yeggman

Search took 7 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.406440125.6
2DLD Change Limit1340271526.12621878.4
3Display Results1521520.0632412.7
 (SQL Overall)1786911526.59527094.9
 
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.