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

165 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
oarsman93773(None) 
oarsmen938091oarsmen
barman103519702bar_man
batsman1157992batsman
boardman1344392boardman
boatsman1245702boatsman
carman103920742car_man
darshan1167062darshan
daysman1335052daysman
gasman92911742ga_sman
marksman1645262marksman
oarswoman1452742oarswoman
yardman1335912yardman
adman84517903_a_dman
aidman92410623_aidman
airman82414223_airman
almsman1145093almsman
aroma71220143_aroma_
aromas81018613_aromas
arshin9312173_arshin
arson55118833_ars_on
ashman1148383_ashman
ataman81013063_ataman
atman75520143_a_tman
axeman1538103_axeman
axman144813183_a_xman
badman113813843ba_dman
bagman114613813ba_gman
bailsman1245003bailsman
bandsman1346753bandsman
barchan1469133barchan
bargeman1345143bargeman
barmen105418533bar_men
baseman1138553baseman
batman105214063ba_tman
batsmen1146883batsmen
bayman133712703ba_yman
beadsman1355613beadsman
birdman1236673birdman
boardmen1344073boardmen
boatman1147053boa_tman
boatsmen1245283boatsmen
bondsman1345693bondsman
busman10310253_busman
cabman123812503ca_bman
caiman103615663ca_iman
capstan1137903capstan
caravan1239233caravan
carmen104019343car_men
caveman1437073caveman
cayman133613213ca_yman
clansman1245813clansman
coachman1744983coachman
coarsen93210323coars_en
corpsman1445133corpsman
cragsman1345213cragsman
dairyman1443493dairyman
dalesman1145803dalesman
daman84821163da__man
darshans1286543darshans
daysmen1335083daysmen
desman9311693_desman
doorman1037063door_man
drayman1335433drayman
earthman1346473earthman
fireman1249333fireman
firman112211343fir_man
foilsman1353773foilsman
foreman12312363foreman
gagman103811243ga_gman
gamesman1344523gamesman
gasmen93111563ga_smen
gateman1057473gateman
german9611983ger_man
glassman1145183glassman
gownsman1443453gownsman
guardsman1342523guardsman
hackman1836433hackman
hangman1337813hangman
hanuman1237133hanuman
hardpan1336443hardpan
harijan1735783harijan
harmin113117393har_min
harshen1339283harshen
headsman1446353headsman
herdman13238423herdman
herdsman1465643herdsman
hoarsen10367993hoars_en
horseman1346823horseman
jasmin1538073ja_smin
jazzman2442553jazzman
juryman1943583juryman
karma113415003kar_ma_
karmas123013733kar_mas
kinsman1335963kinsman
kirkman1243773kirkman
landman1038923landman
landsman1156853landsman
lawman11289053la_wman
layman113511303la_yman
leadsman1145243leadsman
lensman937563lensman
madman113712383ma_dman
mailman1137733mailman
marksmen1644533marksmen
marshal1238973marshal
martian93514683martian
merman10513863mer_man
messman1137283messman
newsman1245503newsman
oars46846033oars___
oarswomen1443373oarswomen
oilman839483o_ilman
organ6915393o_r_gan
origan7310693o_rigan
orphan1137733o_rphan
ottoman946283ottoman
outman83115033o_utman
outspan938743outspan
ovarian1037643ovar_ian
overman12311463overman
packman1736693packman
paesan85114093paes_an
paisan84417073pais_an
parian83223963par_ian
parson83817903pars_on
partan83820563par_tan
preman104117453_preman
raftsman1344163raftsman
ragman94013713ra_gman
reman75730153__reman
rodsman1036653rodsman
roman75424823__roman
sagaman10117563sagaman
salesman1047353salesman
sandman10310173sandman
saran53730303sar__an
sarsar63011843sars_ar
sarsen6314233sars_en
sonarman1045563sonar_man
surfman1236203surfman
talesman1046693talesman
talisman1045553talisman
tarama8412733tarama_
taramas9612703taramas
tarmac10310333tar_mac
tarpan82814293tar_pan
tarsal63315273tars_al
tarsia65514273tarsia_
tarsias74013373tarsias
tartan64217513tar_tan
tarzan152910753tar_zan
taximan1635783taximan
taxman15328613ta_xman
townsman1344103townsman
trashman1345813trashman
turfman1243983turfman
vanman1139793va_nman
verseman1345383verseman
warsaw1236193wars_aw
wireman1237843wireman
woodsman1444793woodsman
workman1635613workman
yardmen1335423yardmen
yasmak1534593ya_smak

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.406440125.6
2DLD Change Limit1340271657.34318252.3
3Display Results1651650.0632619.0
 (SQL Overall)1786911657.81222873.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.