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

192 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
gatemen104760(None) 
gateman1057471gateman
axemen1547492_axemen
basemen1139082basemen
batmen104414302bat_men
batsmen1146882batsmen
cavemen1437142cavemen
gagmen103910412ga_gmen
gamesmen1345112gamesmen
gasmen93111562ga_smen
gleemen1035722gleemen
lateen64014862late_en
sateen63815012sate_en
watermen1377612watermen
abatement1348183abatement
acumen1049013_acumen
admen84516183_a_dmen
agnomen1036763agnomen
aidmen92610373_aidmen
airmen82612353_airmen
amen66733153_a__men
ashmen1168173_ashmen
ataman81013063_ataman
atman75520143_at_man
atween9166613_atween
automen939653automen
axeman1538103_axeman
axmen145112273_a_xmen
badmen114613833ba_dmen
bagmen115412533ba_gmen
baleen8613053bale_en
bargemen1346403bargemen
barmen105418533ba_rmen
baseman1138553baseman
basement12311493basement
batman105214063bat_man
batsman1157993batsman
battement1357773battement
batten85217123bat_ten
baymen134212003ba_ymen
bedemen12910183bedemen
bitumen1134503bitumen
boatmen1146913boat_men
boatsmen1245283boatsmen
brakemen1644843brakemen
cabmen123610653ca_bmen
canteen9411083cante_en
careen84119493care_en
carmen104019343ca_rmen
casement12311953casement
cateran9313773cateran
catered103117773catered
caterer92815943caterer
cattlemen1344333cattlemen
caveman1437073caveman
daemon9279593da_emon
daimen92210573da_imen
dalesmen1146203dalesmen
daysmen1335083daysmen
earthmen1346393earthmen
easement10414163easement
eaten55323053eat__en
fatten94314903fat_ten
firemen1238773firemen
foemen11310523_foemen
foremen12412923foremen
freemen1238463freemen
gaen57329603ga___en
gagman103811243ga_gman
galeae74717453galeae_
galere73716673galere_
galeres83514333galeres
game76644323ga__me_
gamed95126393ga__med
gamelan10106643gamelan
gamer84928943ga__mer
games86238553ga__mes
gamesman1344523gamesman
gamete9313593gamete_
gametes10312253gametes
gamey115320553ga__mey
gamin84423003ga__min
gammed124216163ga_mmed
gammer1112318333ga_mmer
gammon1138903ga_mmon
garagemen1363763garagemen
garden84215083ga_rden
garment10315233ga_rment
gartered10319583gartered
gasman92911743ga_sman
gate55746573gat__e_
gateau778113gate_au
gateaus866333gateaus
gateaux1573123gateaux
gated75329773gat__ed
gateless9279953gateless
gater64533653gat__er
gaters74728643gate_rs
gates65939513gat__es
gateway1434933gateway
gather104115853gat_her
gathered13149373gathered
gatherer12147903gatherer
gaumed104610323ga_umed
gaveled12399133gaveled
gentlemen1243853gentlemen
germen9612313g_ermen
glassmen1145393glassmen
gleeman1035363gleeman
goatee73219533goate_e_
goateed9307063goate_ed
goatees82710443goate_es
goodmen1135623goodmen
gotten73410113got_ten
grantsmen1294643grantsmen
gravamen1443933gravamen
green65522143g_re_en
gripmen1235033gripmen
gunmen9348723g_unmen
hackmen1836713hackmen
haemin113412663ha_emin
hangmen1337383hangmen
hitmen11239193hit_men
hotelmen1344193hotelmen
icemen1037893_icemen
itemed936603_itemed
jazzmen2442503jazzmen
landmen1038553landmen
lateens74210553late_ens
laten54328343lat__en
latened8711923latened
latexes1438313latexes
latten65018203lat_ten
lawmen11308593la_wmen
laymen113010843la_ymen
linemen938633linemen
madmen113511743ma_dmen
mailmen1137273mailmen
meatmen1138243meat_men
oarsmen938093oarsmen
oaten55222403oat__en
packmen1746313packmen
paten74827343pat__en
patten84418193pat_ten
pavement1549443pavement
pikemen1535333pikemen
pitmen102510793pit_men
placemen1445783placemen
poteen83514263pote_en
potmen102713093pot_men
premen105017803_premen
putamen1135923putamen
raceme1039733raceme_
racemed1237013racemed
racemes1139093racemes
raftsmen1343953raftsmen
ragmen93712183ra_gmen
ramen75625193ra__men
ratteen7329113ratteen
ratten64217383rat_ten
routemen10105813routemen
sagamen10127503sagamen
salesmen1047253salesmen
sandmen1039413sandmen
sateens73710753sate_ens
satem76021463satem__
semen75724103__semen
sidemen1037943sidemen
sokemen1337053sokemen
spacemen1445413spacemen
stamen84115943_stamen
statement1148793statement
statesmen1144163statesmen
talesmen1047013talesmen
taxeme1536253taxeme_
taxemes1635853taxemes
taximen1644923taximen
taxmen15367443ta_xmen
teen45938203__te_en
tegmen988403__tegmen
telemen9310173telemen
titmen8239883tit_men
vanmen1138403va_nmen
watchmen1844753watchmen
watered113014953watered
waterer103314073waterer
waterhen1485303waterhen
waterman1397283waterman
whalemen1644473whalemen
wiremen1236903wiremen
yamen104115183ya__men
yardmen1335423yardmen

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 Limit1340271926.09321996.9
3Display Results1921920.0633047.6
 (SQL Overall)1786911926.56227231.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.